/*
 FastAdmin Install SQL
 Date: 2023-06-07 15:17:57
*/

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fa_admin
-- ----------------------------
CREATE TABLE `fa_admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(20) DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) DEFAULT '' COMMENT '昵称',
  `password` varchar(32) DEFAULT '' COMMENT '密码',
  `salt` varchar(30) DEFAULT '' COMMENT '密码盐',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像',
  `email` varchar(100) DEFAULT '' COMMENT '电子邮箱',
  `mobile` varchar(11) DEFAULT '' COMMENT '手机号码',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `logintime` bigint(16) DEFAULT NULL COMMENT '登录时间',
  `loginip` varchar(50) DEFAULT NULL COMMENT '登录IP',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `token` varchar(59) DEFAULT '' COMMENT 'Session标识',
  `status` varchar(30) NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='管理员表';

-- ----------------------------
-- Records of fa_admin
-- ----------------------------
BEGIN;
INSERT INTO `fa_admin` VALUES (1, 'admin', 'Admin', '', '', '/assets/img/avatar.png', 'admin@admin.com', '', 0, 1491635035, '127.0.0.1',1491635035, 1491635035, '', 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_admin_log
-- ----------------------------
CREATE TABLE `fa_admin_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `username` varchar(30) DEFAULT '' COMMENT '管理员名字',
  `url` varchar(1500) DEFAULT '' COMMENT '操作页面',
  `title` varchar(100) DEFAULT '' COMMENT '日志标题',
  `content` longtext NOT NULL COMMENT '内容',
  `ip` varchar(50) DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) DEFAULT '' COMMENT 'User-Agent',
  `createtime` bigint(16) DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `name` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='管理员日志表';

-- ----------------------------
-- Table structure for fa_area
-- ----------------------------
CREATE TABLE `fa_area` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(10) DEFAULT NULL COMMENT '父id',
  `shortname` varchar(100) DEFAULT NULL COMMENT '简称',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `mergename` varchar(255) DEFAULT NULL COMMENT '全称',
  `level` tinyint(4) DEFAULT NULL COMMENT '层级:1=省,2=市,3=区/县',
  `pinyin` varchar(100) DEFAULT NULL COMMENT '拼音',
  `code` varchar(100) DEFAULT NULL COMMENT '长途区号',
  `zip` varchar(100) DEFAULT NULL COMMENT '邮编',
  `first` varchar(50) DEFAULT NULL COMMENT '首字母',
  `lng` varchar(100) DEFAULT NULL COMMENT '经度',
  `lat` varchar(100) DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='地区表';

-- ----------------------------
-- Table structure for fa_attachment
-- ----------------------------
CREATE TABLE `fa_attachment` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `category` varchar(50) DEFAULT '' COMMENT '类别',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `url` varchar(255) DEFAULT '' COMMENT '物理路径',
  `imagewidth` varchar(30) DEFAULT '' COMMENT '宽度',
  `imageheight` varchar(30) DEFAULT '' COMMENT '高度',
  `imagetype` varchar(30) DEFAULT '' COMMENT '图片类型',
  `imageframes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
  `filename` varchar(100) DEFAULT '' COMMENT '文件名称',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `mimetype` varchar(100) DEFAULT '' COMMENT 'mime类型',
  `extparam` varchar(255) DEFAULT '' COMMENT '透传数据',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建日期',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `uploadtime` bigint(16) DEFAULT NULL COMMENT '上传时间',
  `storage` varchar(100) NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(40) DEFAULT '' COMMENT '文件 sha1编码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='附件表';

-- ----------------------------
-- Table structure for fa_auth_group
-- ----------------------------
CREATE TABLE `fa_auth_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父组别',
  `name` varchar(100) DEFAULT '' COMMENT '组名',
  `rules` text NOT NULL COMMENT '规则ID',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `status` varchar(30) DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='分组表';

-- ----------------------------
-- Records of fa_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group` VALUES (1, 0, 'Admin group', '*', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (2, 1, 'Second group', '13,14,16,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,1,9,10,11,7,6,8,2,4,5', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (3, 2, 'Third group', '1,4,9,10,11,13,14,15,16,17,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,5', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (4, 1, 'Second group 2', '1,4,13,14,15,16,17,55,56,57,58,59,60,61,62,63,64,65', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (5, 2, 'Third group 2', '1,2,6,7,8,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34', 1491635035, 1491635035, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_auth_group_access
-- ----------------------------
CREATE TABLE `fa_auth_group_access` (
  `uid` int(10) unsigned NOT NULL COMMENT '会员ID',
  `group_id` int(10) unsigned NOT NULL COMMENT '级别ID',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='权限分组表';

-- ----------------------------
-- Records of fa_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group_access` VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for fa_auth_rule
-- ----------------------------
CREATE TABLE `fa_auth_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('menu','file') NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(100) DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) DEFAULT '' COMMENT '图标',
  `url` varchar(255) DEFAULT '' COMMENT '规则URL',
  `condition` varchar(255) DEFAULT '' COMMENT '条件',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
  `menutype` enum('addtabs','blank','dialog','ajax') DEFAULT NULL COMMENT '菜单类型',
  `extend` varchar(255) DEFAULT '' COMMENT '扩展属性',
  `py` varchar(30) DEFAULT '' COMMENT '拼音首字母',
  `pinyin` varchar(100) DEFAULT '' COMMENT '拼音',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `pid` (`pid`),
  KEY `weigh` (`weigh`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='节点表';

-- ----------------------------
-- Records of fa_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_rule` VALUES (2, 'file', 0, 'general', 'General', 'fa fa-cogs', '', '', '', 1, NULL, '', 'cggl', 'changguiguanli', 1491635035, 1491635035, 137, 'normal');

INSERT INTO `fa_auth_rule` VALUES (5, 'file', 0, 'auth', 'Auth', 'fa fa-group', '', '', '', 1, NULL, '', 'qxgl', 'quanxianguanli', 1491635035, 1491635035, 99, 'normal');
INSERT INTO `fa_auth_rule` VALUES (6, 'file', 2, 'general/config', 'Config', 'fa fa-cog', '', '', 'Config tips', 1, NULL, '', 'xtpz', 'xitongpeizhi', 1491635035, 1491635035, 60, 'normal');
INSERT INTO `fa_auth_rule` VALUES (7, 'file', 2, 'general/attachment', 'Attachment', 'fa fa-file-image-o', '', '', 'Attachment tips', 1, NULL, '', 'fjgl', 'fujianguanli', 1491635035, 1491635035, 53, 'normal');
INSERT INTO `fa_auth_rule` VALUES (8, 'file', 2, 'general/profile', 'Profile', 'fa fa-user', '', '', '', 1, NULL, '', 'grzl', 'gerenziliao', 1491635035, 1491635035, 34, 'normal');
INSERT INTO `fa_auth_rule` VALUES (9, 'file', 5, 'auth/admin', 'Admin', 'fa fa-user', '', '', 'Admin tips', 1, NULL, '', 'glygl', 'guanliyuanguanli', 1491635035, 1491635035, 118, 'normal');
INSERT INTO `fa_auth_rule` VALUES (10, 'file', 5, 'auth/adminlog', 'Admin log', 'fa fa-list-alt', '', '', 'Admin log tips', 1, NULL, '', 'glyrz', 'guanliyuanrizhi', 1491635035, 1491635035, 113, 'normal');
INSERT INTO `fa_auth_rule` VALUES (11, 'file', 5, 'auth/group', 'Group', 'fa fa-group', '', '', 'Group tips', 1, NULL, '', 'jsz', 'juesezu', 1491635035, 1491635035, 109, 'normal');
INSERT INTO `fa_auth_rule` VALUES (12, 'file', 5, 'auth/rule', 'Rule', 'fa fa-bars', '', '', 'Rule tips', 1, NULL, '', 'cdgz', 'caidanguize', 1491635035, 1491635035, 104, 'normal');
INSERT INTO `fa_auth_rule` VALUES (18, 'file', 6, 'general/config/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 52, 'normal');
INSERT INTO `fa_auth_rule` VALUES (19, 'file', 6, 'general/config/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 51, 'normal');
INSERT INTO `fa_auth_rule` VALUES (20, 'file', 6, 'general/config/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 50, 'normal');
INSERT INTO `fa_auth_rule` VALUES (21, 'file', 6, 'general/config/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 49, 'normal');
INSERT INTO `fa_auth_rule` VALUES (22, 'file', 6, 'general/config/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 48, 'normal');
INSERT INTO `fa_auth_rule` VALUES (23, 'file', 7, 'general/attachment/index', 'View', 'fa fa-circle-o', '', '', 'Attachment tips', 0, NULL, '', '', '', 1491635035, 1491635035, 59, 'normal');
INSERT INTO `fa_auth_rule` VALUES (24, 'file', 7, 'general/attachment/select', 'Select attachment', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 58, 'normal');
INSERT INTO `fa_auth_rule` VALUES (25, 'file', 7, 'general/attachment/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 57, 'normal');
INSERT INTO `fa_auth_rule` VALUES (26, 'file', 7, 'general/attachment/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 56, 'normal');
INSERT INTO `fa_auth_rule` VALUES (27, 'file', 7, 'general/attachment/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 55, 'normal');
INSERT INTO `fa_auth_rule` VALUES (28, 'file', 7, 'general/attachment/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 54, 'normal');
INSERT INTO `fa_auth_rule` VALUES (29, 'file', 8, 'general/profile/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 33, 'normal');
INSERT INTO `fa_auth_rule` VALUES (30, 'file', 8, 'general/profile/update', 'Update profile', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 32, 'normal');
INSERT INTO `fa_auth_rule` VALUES (31, 'file', 8, 'general/profile/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 31, 'normal');
INSERT INTO `fa_auth_rule` VALUES (32, 'file', 8, 'general/profile/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 30, 'normal');
INSERT INTO `fa_auth_rule` VALUES (33, 'file', 8, 'general/profile/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 29, 'normal');
INSERT INTO `fa_auth_rule` VALUES (34, 'file', 8, 'general/profile/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 28, 'normal');

INSERT INTO `fa_auth_rule` VALUES (40, 'file', 9, 'auth/admin/index', 'View', 'fa fa-circle-o', '', '', 'Admin tips', 0, NULL, '', '', '', 1491635035, 1491635035, 117, 'normal');
INSERT INTO `fa_auth_rule` VALUES (41, 'file', 9, 'auth/admin/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 116, 'normal');
INSERT INTO `fa_auth_rule` VALUES (42, 'file', 9, 'auth/admin/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 115, 'normal');
INSERT INTO `fa_auth_rule` VALUES (43, 'file', 9, 'auth/admin/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 114, 'normal');
INSERT INTO `fa_auth_rule` VALUES (44, 'file', 10, 'auth/adminlog/index', 'View', 'fa fa-circle-o', '', '', 'Admin log tips', 0, NULL, '', '', '', 1491635035, 1491635035, 112, 'normal');
INSERT INTO `fa_auth_rule` VALUES (45, 'file', 10, 'auth/adminlog/detail', 'Detail', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 111, 'normal');
INSERT INTO `fa_auth_rule` VALUES (46, 'file', 10, 'auth/adminlog/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 110, 'normal');
INSERT INTO `fa_auth_rule` VALUES (47, 'file', 11, 'auth/group/index', 'View', 'fa fa-circle-o', '', '', 'Group tips', 0, NULL, '', '', '', 1491635035, 1491635035, 108, 'normal');
INSERT INTO `fa_auth_rule` VALUES (48, 'file', 11, 'auth/group/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 107, 'normal');
INSERT INTO `fa_auth_rule` VALUES (49, 'file', 11, 'auth/group/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 106, 'normal');
INSERT INTO `fa_auth_rule` VALUES (50, 'file', 11, 'auth/group/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 105, 'normal');
INSERT INTO `fa_auth_rule` VALUES (51, 'file', 12, 'auth/rule/index', 'View', 'fa fa-circle-o', '', '', 'Rule tips', 0, NULL, '', '', '', 1491635035, 1491635035, 103, 'normal');
INSERT INTO `fa_auth_rule` VALUES (52, 'file', 12, 'auth/rule/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 102, 'normal');
INSERT INTO `fa_auth_rule` VALUES (53, 'file', 12, 'auth/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 101, 'normal');
INSERT INTO `fa_auth_rule` VALUES (54, 'file', 12, 'auth/rule/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 100, 'normal');
INSERT INTO `fa_auth_rule` VALUES (55, 'file', 4, 'addon/index', 'View', 'fa fa-circle-o', '', '', 'Addon tips', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (56, 'file', 4, 'addon/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (57, 'file', 4, 'addon/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (58, 'file', 4, 'addon/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (59, 'file', 4, 'addon/downloaded', 'Local addon', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (60, 'file', 4, 'addon/state', 'Update state', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (63, 'file', 4, 'addon/config', 'Setting', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (64, 'file', 4, 'addon/refresh', 'Refresh', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (65, 'file', 4, 'addon/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');

COMMIT;

-- ----------------------------
-- Table structure for fa_category
-- ----------------------------
CREATE TABLE `fa_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `type` varchar(30) DEFAULT '' COMMENT '栏目类型',
  `name` varchar(30) DEFAULT '',
  `nickname` varchar(50) DEFAULT '',
  `flag` set('hot','index','recommend') DEFAULT '',
  `image` varchar(100) DEFAULT '' COMMENT '图片',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键字',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `diyname` varchar(30) DEFAULT '' COMMENT '自定义名称',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `weigh` (`weigh`,`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='分类表';


-- ----------------------------
-- Table structure for fa_config
-- ----------------------------
CREATE TABLE `fa_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT '' COMMENT '变量名',
  `group` varchar(30) DEFAULT '' COMMENT '分组',
  `title` varchar(100) DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
  `visible` varchar(255) DEFAULT '' COMMENT '可见条件',
  `value` text COMMENT '变量值',
  `content` text COMMENT '变量字典数据',
  `rule` varchar(100) DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) DEFAULT '' COMMENT '扩展属性',
  `setting` varchar(255) DEFAULT '' COMMENT '配置',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='系统配置';

-- ----------------------------
-- Records of fa_config
-- ----------------------------
BEGIN;
INSERT INTO `fa_config` VALUES (1, 'name', 'basic', 'Site name', '请填写站点名称', 'string', '', '我的网站', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (2, 'beian', 'basic', 'Beian', '', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (3, 'cdnurl', 'basic', 'Cdn url', '如果全站静态资源使用第三方云储存请配置该值', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (4, 'version', 'basic', 'Version', '如果静态资源有变动请重新配置该值', 'string', '', '1.0.1', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (5, 'timezone', 'basic', 'Timezone', '', 'string', '', 'Asia/Shanghai', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (6, 'forbiddenip', 'basic', 'Forbidden ip', '一行一条记录', 'text', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (7, 'languages', 'basic', 'Languages', '', 'array', '', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (8, 'fixedpage', 'basic', 'Fixed page', '请输入左侧菜单栏存在的链接', 'string', '', 'deerhome/info', '', 'required', '', '');
INSERT INTO `fa_config` VALUES (9, 'categorytype', 'dictionary', 'Category type', '', 'array', '', '{\"default\":\"Default\",\"page\":\"Page\",\"article\":\"Article\",\"test\":\"Test\"}', '', '', '', '');
INSERT INTO `fa_config` VALUES (10, 'configgroup', 'dictionary', 'Config group', '', 'array', '', '{\"basic\":\"Basic\",\"email\":\"Email\",\"dictionary\":\"Dictionary\",\"user\":\"User\",\"example\":\"Example\"}', '', '', '', '');
INSERT INTO `fa_config` VALUES (11, 'mail_type', 'email', 'Mail type', '选择邮件发送方式', 'select', '', '1', '[\"请选择\",\"SMTP\"]', '', '', '');
INSERT INTO `fa_config` VALUES (12, 'mail_smtp_host', 'email', 'Mail smtp host', '错误的配置发送邮件会导致服务器超时', 'string', '', 'smtp.qq.com', '', '', '', '');
INSERT INTO `fa_config` VALUES (13, 'mail_smtp_port', 'email', 'Mail smtp port', '(不加密默认25,SSL默认465,TLS默认587)', 'string', '', '465', '', '', '', '');
INSERT INTO `fa_config` VALUES (14, 'mail_smtp_user', 'email', 'Mail smtp user', '（填写完整用户名）', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (15, 'mail_smtp_pass', 'email', 'Mail smtp password', '（填写您的密码或授权码）', 'password', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (16, 'mail_verify_type', 'email', 'Mail vertify type', '（SMTP验证方式[推荐SSL]）', 'select', '', '2', '[\"无\",\"TLS\",\"SSL\"]', '', '', '');
INSERT INTO `fa_config` VALUES (17, 'mail_from', 'email', 'Mail from', '', 'string', '', '', '', '', '', '');
INSERT INTO `fa_config` VALUES (18, 'attachmentcategory', 'dictionary', 'Attachment category', '', 'array', '', '{\"category1\":\"Category1\",\"category2\":\"Category2\",\"custom\":\"Custom\"}', '', '', '', '');
INSERT INTO `fa_config` VALUES (19, 'admin_logo', 'basic', '后台logo', '', 'image', '', '/logo-bar.png', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
COMMIT;

-- ----------------------------
-- Table structure for fa_ems
-- ----------------------------
CREATE TABLE `fa_ems`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) DEFAULT '' COMMENT '事件',
  `email` varchar(100) DEFAULT '' COMMENT '邮箱',
  `code` varchar(10) DEFAULT '' COMMENT '验证码',
  `times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数',
  `ip` varchar(30) DEFAULT '' COMMENT 'IP',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='邮箱验证码表';

-- ----------------------------
-- Table structure for fa_sms
-- ----------------------------
CREATE TABLE `fa_sms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) DEFAULT '' COMMENT '事件',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `code` varchar(10) DEFAULT '' COMMENT '验证码',
  `times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(30) DEFAULT '' COMMENT 'IP',
  `createtime` bigint(16) unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='短信验证码表';

-- ----------------------------
-- Table structure for fa_test
-- ----------------------------
CREATE TABLE `fa_test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(10) DEFAULT '0' COMMENT '会员ID',
  `admin_id` int(10) DEFAULT '0' COMMENT '管理员ID',
  `category_id` int(10) unsigned DEFAULT '0' COMMENT '分类ID(单选)',
  `category_ids` varchar(100) COMMENT '分类ID(多选)',
  `tags` varchar(255) DEFAULT '' COMMENT '标签',
  `week` enum('monday','tuesday','wednesday') COMMENT '星期(单选):monday=星期一,tuesday=星期二,wednesday=星期三',
  `flag` set('hot','index','recommend') DEFAULT '' COMMENT '标志(多选):hot=热门,index=首页,recommend=推荐',
  `genderdata` enum('male','female') DEFAULT 'male' COMMENT '性别(单选):male=男,female=女',
  `hobbydata` set('music','reading','swimming') COMMENT '爱好(多选):music=音乐,reading=读书,swimming=游泳',
  `title` varchar(100) DEFAULT '' COMMENT '标题',
  `content` text COMMENT '内容',
  `image` varchar(100) DEFAULT '' COMMENT '图片',
  `images` varchar(1500) DEFAULT '' COMMENT '图片组',
  `attachfile` varchar(100) DEFAULT '' COMMENT '附件',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键字',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `city` varchar(100) DEFAULT '' COMMENT '省市',
  `array` varchar(255) DEFAULT '' COMMENT '数组:value=值',
  `json` varchar(255) DEFAULT '' COMMENT '配置:key=名称,value=值',
  `multiplejson` varchar(1500) DEFAULT '' COMMENT '二维数组:title=标题,intro=介绍,author=作者,age=年龄',
  `price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '价格',
  `views` int(10) unsigned DEFAULT '0' COMMENT '点击',
  `workrange` varchar(100) DEFAULT '' COMMENT '时间区间',
  `startdate` date DEFAULT NULL COMMENT '开始日期',
  `activitytime` datetime DEFAULT NULL COMMENT '活动时间(datetime)',
  `year` year(4) DEFAULT NULL COMMENT '年',
  `times` time DEFAULT NULL COMMENT '时间',
  `refreshtime` bigint(16) DEFAULT NULL COMMENT '刷新时间',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
  `weigh` int(10) DEFAULT '0' COMMENT '权重',
  `switch` tinyint(1) DEFAULT '0' COMMENT '开关',
  `status` enum('normal','hidden') DEFAULT 'normal' COMMENT '状态',
  `state` enum('0','1','2') DEFAULT '1' COMMENT '状态值:0=禁用,1=正常,2=推荐',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='测试表';

-- ----------------------------
-- Records of fa_test
-- ----------------------------
BEGIN;
INSERT INTO `fa_test` VALUES (1, 1, 1, 12, '12,13', '互联网,计算机', 'monday', 'hot,index', 'male', 'music,reading', '我是一篇测试文章', '<p>我是测试内容</p>', '/assets/img/avatar.png', '/assets/img/avatar.png,/assets/img/qrcode.png', '/assets/img/avatar.png', '关键字', '我是一篇测试文章描述，内容过多时将自动隐藏', '广西壮族自治区/百色市/平果县', '[\"a\",\"b\"]', '{\"a\":\"1\",\"b\":\"2\"}', '[{\"title\":\"标题一\",\"intro\":\"介绍一\",\"author\":\"小明\",\"age\":\"21\"}]', 0.00, 0, '2020-10-01 00:00:00 - 2021-10-31 23:59:59', '2017-07-10', '2017-07-10 18:24:45', 2017, '18:24:45', 1491635035, 1491635035, 1491635035, NULL, 0, 1, 'normal', '1');
COMMIT;

-- ----------------------------
-- Table structure for fa_user
-- ----------------------------
CREATE TABLE `fa_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '组别ID',
  `username` varchar(32) DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) DEFAULT '' COMMENT '昵称',
  `password` varchar(32) DEFAULT '' COMMENT '密码',
  `salt` varchar(30) DEFAULT '' COMMENT '密码盐',
  `email` varchar(100) DEFAULT '' COMMENT '电子邮箱',
  `mobile` varchar(11) DEFAULT '' COMMENT '手机号',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
  `gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `bio` varchar(100) DEFAULT '' COMMENT '格言',
  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `score` int(10) NOT NULL DEFAULT '0' COMMENT '积分',
  `successions` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '连续登录天数',
  `maxsuccessions` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '最大连续登录天数',
  `prevtime` bigint(16) DEFAULT NULL COMMENT '上次登录时间',
  `logintime` bigint(16) DEFAULT NULL COMMENT '登录时间',
  `loginip` varchar(50) DEFAULT '' COMMENT '登录IP',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `joinip` varchar(50) DEFAULT '' COMMENT '加入IP',
  `jointime` bigint(16) DEFAULT NULL COMMENT '加入时间',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `token` varchar(50) DEFAULT '' COMMENT 'Token',
  `status` varchar(30) DEFAULT '' COMMENT '状态',
  `verification` varchar(255) DEFAULT '' COMMENT '验证',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='会员表';

-- ----------------------------
-- Records of fa_user
-- ----------------------------
BEGIN;
INSERT INTO `fa_user` VALUES (1, 1, 'admin', 'admin', '', '', 'admin@163.com', '13000000000', '', 0, 0, '2017-04-08', '', 0, 0, 1, 1, 1491635035, 1491635035, '127.0.0.1', 0, '127.0.0.1', 1491635035, 0, 1491635035, '', 'normal','');
COMMIT;

-- ----------------------------
-- Table structure for fa_user_group
-- ----------------------------
CREATE TABLE `fa_user_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '' COMMENT '组名',
  `rules` text COMMENT '权限节点',
  `createtime` bigint(16) DEFAULT NULL COMMENT '添加时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `status` enum('normal','hidden') DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='会员组表';

-- ----------------------------
-- Records of fa_user_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_user_group` VALUES (1, '默认组', '1,2,3,4,5,6,7,8,9,10,11,12', 1491635035, 1491635035, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_user_money_log
-- ----------------------------
CREATE TABLE `fa_user_money_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更余额',
  `before` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更前余额',
  `after` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更后余额',
  `memo` varchar(255) DEFAULT '' COMMENT '备注',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='会员余额变动表';

-- ----------------------------
-- Table structure for fa_user_rule
-- ----------------------------
CREATE TABLE `fa_user_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) DEFAULT NULL COMMENT '父ID',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `title` varchar(50) DEFAULT '' COMMENT '标题',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `ismenu` tinyint(1) DEFAULT NULL COMMENT '是否菜单',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) DEFAULT '0' COMMENT '权重',
  `status` enum('normal','hidden') DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='会员规则表';

-- ----------------------------
-- Records of fa_user_rule
-- ----------------------------
BEGIN;
INSERT INTO `fa_user_rule` VALUES (1, 0, 'index', 'Frontend', '', 1, 1491635035, 1491635035, 1, 'normal');
INSERT INTO `fa_user_rule` VALUES (2, 0, 'api', 'API Interface', '', 1, 1491635035, 1491635035, 2, 'normal');
INSERT INTO `fa_user_rule` VALUES (3, 1, 'user', 'User Module', '', 1, 1491635035, 1491635035, 12, 'normal');
INSERT INTO `fa_user_rule` VALUES (4, 2, 'user', 'User Module', '', 1, 1491635035, 1491635035, 11, 'normal');
INSERT INTO `fa_user_rule` VALUES (5, 3, 'index/user/login', 'Login', '', 0, 1491635035, 1491635035, 5, 'normal');
INSERT INTO `fa_user_rule` VALUES (6, 3, 'index/user/register', 'Register', '', 0, 1491635035, 1491635035, 7, 'normal');
INSERT INTO `fa_user_rule` VALUES (7, 3, 'index/user/index', 'User Center', '', 0, 1491635035, 1491635035, 9, 'normal');
INSERT INTO `fa_user_rule` VALUES (8, 3, 'index/user/profile', 'Profile', '', 0, 1491635035, 1491635035, 4, 'normal');
INSERT INTO `fa_user_rule` VALUES (9, 4, 'api/user/login', 'Login', '', 0, 1491635035, 1491635035, 6, 'normal');
INSERT INTO `fa_user_rule` VALUES (10, 4, 'api/user/register', 'Register', '', 0, 1491635035, 1491635035, 8, 'normal');
INSERT INTO `fa_user_rule` VALUES (11, 4, 'api/user/index', 'User Center', '', 0, 1491635035, 1491635035, 10, 'normal');
INSERT INTO `fa_user_rule` VALUES (12, 4, 'api/user/profile', 'Profile', '', 0, 1491635035, 1491635035, 3, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_user_score_log
-- ----------------------------
CREATE TABLE `fa_user_score_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `score` int(10) NOT NULL DEFAULT '0' COMMENT '变更积分',
  `before` int(10) NOT NULL DEFAULT '0' COMMENT '变更前积分',
  `after` int(10) NOT NULL DEFAULT '0' COMMENT '变更后积分',
  `memo` varchar(255) DEFAULT '' COMMENT '备注',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='会员积分变动表';

-- ----------------------------
-- Table structure for fa_user_token
-- ----------------------------
CREATE TABLE `fa_user_token` (
  `token` varchar(50) NOT NULL COMMENT 'Token',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `expiretime` bigint(16) DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='会员Token表';

-- ----------------------------
-- Table structure for fa_version
-- ----------------------------
CREATE TABLE `fa_version`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `oldversion` varchar(30) DEFAULT '' COMMENT '旧版本号',
  `newversion` varchar(30) DEFAULT '' COMMENT '新版本号',
  `packagesize` varchar(30) DEFAULT '' COMMENT '包大小',
  `content` varchar(500) DEFAULT '' COMMENT '升级内容',
  `downloadurl` varchar(255) DEFAULT '' COMMENT '下载地址',
  `enforce` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '强制更新',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
  `status` varchar(30) DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT='版本表';

-- 系统数据库：：开始

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- 表的结构 `__PREFIX__deerhome_agent_lev`
--

CREATE TABLE `__PREFIX__deerhome_agent_lev` (
  `id` int(10) NOT NULL,
  `name` varchar(300) NOT NULL COMMENT '等级名称',
  `lev` int(2) NOT NULL COMMENT '等级权重',
  `lev1` decimal(5,2) NOT NULL COMMENT '上级上浮比例',
  `lev2` decimal(5,2) NOT NULL COMMENT '上上级上浮比例',
  `task` text NOT NULL COMMENT '升级条件',
  `task_type` tinyint(1) DEFAULT '1' COMMENT '条件类型:1=全部满足,2=任意一个',
  `note` varchar(600) DEFAULT NULL COMMENT '描述',
  `bg_image` varchar(300) DEFAULT NULL COMMENT '背景图'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='分销等级';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_article`
--

CREATE TABLE `__PREFIX__deerhome_article` (
  `id` int(10) NOT NULL,
  `cate` tinyint(2) NOT NULL COMMENT '分类',
  `name` varchar(300) NOT NULL COMMENT '标题',
  `con` text NOT NULL COMMENT '内容',
  `see` int(10) DEFAULT '0' COMMENT '阅读次数',
  `add_time` datetime NOT NULL COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章管理';

--
-- 转存表中的数据 `__PREFIX__deerhome_article`
--

INSERT INTO `__PREFIX__deerhome_article` (`id`, `cate`, `name`, `con`, `see`, `add_time`) VALUES
(1, 1, '用户协议', '用户协议内容', 0, '2023-06-20 11:03:07'),
(2, 1, '隐私政策', '隐私政策内容', 0, '2023-06-20 11:06:02'),
(3, 1, '充值协议', '充值协议内容', 0, '2023-06-20 11:06:02'),
(4, 2, '是否可以开发票？', '&lt;p&gt;订单完成之后可在个人中心申请开具增值税普通发票&lt;/p&gt;', 0, '2023-06-30 16:03:15'),
(5, 2, '空调维修后质保多久？', '&lt;p&gt;一般情况是保修半年，具体请联系为您服务的维修师傅。&lt;/p&gt;', 0, '2023-09-10 21:49:44'),
(6, 2, '师傅没有按时上门', '&lt;p&gt;您可以在订单详情，主动联系师傅，询问原因。&lt;/p&gt;', 0, '2023-09-10 21:50:47');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_bank`
--

CREATE TABLE `__PREFIX__deerhome_bank` (
  `id` int(10) NOT NULL,
  `bank` varchar(300) NOT NULL COMMENT '银行',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=启用,2=停用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='银行管理';

--
-- 转存表中的数据 `__PREFIX__deerhome_bank`
--

INSERT INTO `__PREFIX__deerhome_bank` (`id`, `bank`, `status`) VALUES
(1, '招商银行', 1),
(2, '工商银行', 1),
(3, '农业银行', 1),
(4, '中国银行', 1);

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_card`
--

CREATE TABLE `__PREFIX__deerhome_card` (
  `id` int(10) NOT NULL,
  `anget` tinyint(1) DEFAULT '2' COMMENT '参与分销:1=是,2=否',
  `anget_lev1` decimal(5,2) DEFAULT '0.00' COMMENT '上级分佣',
  `anget_lev2` decimal(5,2) DEFAULT '0.00' COMMENT '上上级分佣',
  `name` varchar(300) NOT NULL COMMENT '产品名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=正常,2=下架	',
  `price` decimal(10,2) NOT NULL COMMENT '售价',
  `price_market` decimal(10,2) NOT NULL COMMENT '原价',
  `face_image` varchar(300) DEFAULT NULL COMMENT '封面图',
  `img_images` varchar(600) DEFAULT NULL COMMENT '图片集',
  `createtime` datetime NOT NULL COMMENT '创建时间',
  `updatetime` datetime DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) DEFAULT '100' COMMENT '排序',
  `body_con` text COMMENT '图文详情',
  `view_times` int(10) DEFAULT '0' COMMENT '浏览次数',
  `sale_times` int(10) DEFAULT '0' COMMENT '销量',
  `fake_sale_times` int(10) DEFAULT '0' COMMENT '基础销量',
  `vip_discount` tinyint(1) DEFAULT '2' COMMENT '会员折扣:1=是,2=否',
  `item_show` tinyint(1) DEFAULT '1' COMMENT '产品页展示:1=是,2=否',
  `time_area` tinyint(1) DEFAULT '1' COMMENT '有效期:1=永久,2=月卡,3=季卡,4=年卡',
  `is_home` tinyint(1) DEFAULT '1' COMMENT '首页:1=是,2=否'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='套餐次卡';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_card_items`
--

CREATE TABLE `__PREFIX__deerhome_card_items` (
  `id` int(10) NOT NULL,
  `deerhome_card_id` int(10) NOT NULL,
  `deerhome_items_id` int(10) NOT NULL DEFAULT '0' COMMENT '产品id',
  `deerhome_items_gg_hash` varchar(70) NOT NULL COMMENT '产品规格标识hash',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单价',
  `num` int(10) NOT NULL COMMENT '次数'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='套餐内产品';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_card_order`
--

CREATE TABLE `__PREFIX__deerhome_card_order` (
  `id` int(10) NOT NULL,
  `deerhome_user_id` int(10) NOT NULL COMMENT '用户id',
  `sn` varchar(50) NOT NULL COMMENT '订单号',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待支付,2=使用中,3=已用完',
  `deerhome_card_id` int(10) NOT NULL COMMENT '套餐id',
  `deerhome_card_name` varchar(300) NOT NULL COMMENT '套餐名称',
  `price` decimal(10,2) NOT NULL COMMENT '原价',
  `price_yh` decimal(10,2) NOT NULL COMMENT '优惠金额',
  `price_need_pay` decimal(10,2) NOT NULL COMMENT '订单金额',
  `price_payed` decimal(10,2) DEFAULT '0.00' COMMENT '实际支付',
  `add_time` datetime NOT NULL COMMENT '创建时间',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `done_time` datetime DEFAULT NULL COMMENT '完成时间',
  `agent_lev1_uid` int(10) DEFAULT '0' COMMENT '上级uid',
  `agent_lev1_percent` decimal(10,2) DEFAULT '0.00' COMMENT '上级分佣百分比',
  `agent_lev1_price` decimal(10,2) DEFAULT '0.00' COMMENT '上级分佣',
  `agent_lev1_price_note` varchar(300) DEFAULT NULL COMMENT '上级分佣备注',
  `agent_lev1_price_js` tinyint(1) DEFAULT '2' COMMENT '上级是否结算:1=是,2=否',
  `agent_lev2_uid` int(10) DEFAULT '0' COMMENT '上上级uid',
  `agent_lev2_percent` decimal(10,2) DEFAULT '0.00' COMMENT '上上级分佣百分比',
  `agent_lev2_price` decimal(10,2) DEFAULT '0.00' COMMENT '上上级分佣',
  `agent_lev2_price_note` varchar(300) DEFAULT NULL COMMENT '上上级分佣备注',
  `agent_lev2_price_js` tinyint(1) DEFAULT '2' COMMENT '上上级是否结算:1=是,2=否',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `time_area` tinyint(1) DEFAULT '0' COMMENT '套餐时长:同card表',
  `num_left` int(10) DEFAULT '0' COMMENT '剩余次数',
  `num_total` int(10) DEFAULT '0' COMMENT '总次数',
  `price_yh_note` varchar(300) DEFAULT NULL COMMENT '优惠说明'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='套餐订单';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_card_order_items`
--

CREATE TABLE `__PREFIX__deerhome_card_order_items` (
  `id` int(10) NOT NULL,
  `deerhome_card_order_id` int(10) NOT NULL COMMENT '套餐订单id',
  `deerhome_items_id` int(10) NOT NULL COMMENT '产品id',
  `deerhome_items_name` varchar(300) NOT NULL COMMENT '产品名称',
  `gg_name` varchar(300) NOT NULL COMMENT '规格产品名称',
  `gg_price` decimal(10,2) NOT NULL COMMENT '规格产品价格',
  `gg_dw` varchar(100) NOT NULL COMMENT '规格产品单位',
  `deerhome_items_gg_hash` varchar(100) NOT NULL COMMENT '产品规格标识',
  `price` decimal(10,2) NOT NULL COMMENT '套餐内售价',
  `num` int(10) NOT NULL COMMENT '数量',
  `num_left` int(10) NOT NULL COMMENT '剩余数量'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='套餐订单产品';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_cate`
--

CREATE TABLE `__PREFIX__deerhome_cate` (
  `id` int(10) NOT NULL,
  `cate_type` tinyint(1) DEFAULT '1' COMMENT '类型:1=服务,2=商品',
  `can_apply` tinyint(1) DEFAULT '1' COMMENT '是否支持入驻:1=是，2否',
  `home` tinyint(1) DEFAULT '2' COMMENT '首页展示:1=是,2否',
  `face_image` varchar(300) DEFAULT NULL COMMENT '封面图',
  `name` varchar(300) NOT NULL COMMENT '名称',
  `cate_id` int(10) DEFAULT '0' COMMENT '上级类目',
  `status` enum('1','2') DEFAULT '1' COMMENT '状态:1=正常,2=停用',
  `weigh` int(10) DEFAULT '100',
  `ad_image` varchar(300) DEFAULT NULL COMMENT '广告图',
  `ad_image_ac` varchar(300) DEFAULT NULL COMMENT '广告图事件',
  `createtime` bigint(16) DEFAULT '0' COMMENT '创建时间	',
  `updatetime` bigint(16) DEFAULT '0' COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='服务类目';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_config`
--

CREATE TABLE `__PREFIX__deerhome_config` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(30) DEFAULT '' COMMENT '变量名',
  `group` varchar(30) DEFAULT '' COMMENT '分组',
  `title` varchar(100) DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
  `visible` varchar(255) DEFAULT '' COMMENT '可见条件',
  `value` text COMMENT '变量值',
  `content` text COMMENT '变量字典数据',
  `rule` varchar(100) DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) DEFAULT '' COMMENT '扩展属性',
  `setting` varchar(255) DEFAULT '' COMMENT '配置',
  `is_encode` tinyint(1) DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统配置';

--
-- 转存表中的数据 `__PREFIX__deerhome_config`
--

INSERT INTO `__PREFIX__deerhome_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`, `is_encode`) VALUES
(19, 'accessKeyId', 'sms', 'accessKeyId', '不填则无短信通知', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(20, 'accessKeySecret', 'sms', 'accessKeySecret', '不填则无短信通知', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(21, 'sign', 'sms', '短信签名', '不填则无短信通知', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(22, 'ip2city', 'other', 'IP转城市AppCode', '不配置小程序端则不显示城市；阿里云市场API：https://market.aliyun.com/products/57002003/cmapi021970.html', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(23, 'qq_map_key', 'other', '腾讯地图key', '不配置后台订单详情则不显示地图', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(24, 'gh_app_id', 'wechat', '公众号appId', '', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(25, 'gh_app_secret', 'wechat', '公众号appSecret', '', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(26, 'regionId', 'sms', '地区', '', 'string', '', 'cn-hangzhou', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(27, 'yzm_code', 'sms', '验证码模板CODE', '以SMS_开头的代码，请确保验证码模板的变量值为${code}，且只有1个变量', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(28, 'wechat_app_id', 'wechat_app', '小程序appId', '', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(29, 'wechat_app_secret', 'wechat_app', '小程序appSecret', '', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(30, 'wechat_app_mch_id', 'wechat_pay', '商户号mch_id', '', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(31, 'wechat_app_mch_v3_key', 'wechat_pay', '商户APIv3密钥', '', 'string', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(32, 'wechat_app_mch_cert', 'wechat_pay', 'API证书cert.pem', '请上传apiclient_cert.pem', 'file', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(33, 'wechat_app_mch_key', 'wechat_pay', 'API证书key.pem', '请上传apiclient_key.pem', 'file', '', '', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 1),
(34, 'worker_km', 'other', '工人接单最大范围(km)', '工人接单最大范围，超出范围的订单将不展示', 'number', '', '20', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2),
(35, 'worker_get_order', 'other', '师傅抢单模式', '关闭后师傅端将不可以抢单', 'switch', '', '1', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}', 2);


-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_design`
--

CREATE TABLE `__PREFIX__deerhome_design` (
  `id` int(10) NOT NULL,
  `page_title` varchar(100) NOT NULL,
  `page` varchar(20) NOT NULL,
  `con` text NOT NULL,
  `weigh` int(10) NOT NULL,
  `update_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='页面设计';

--
-- 转存表中的数据 `__PREFIX__deerhome_design`
--

INSERT INTO `__PREFIX__deerhome_design` (`id`, `page_title`, `page`, `con`, `weigh`, `update_time`) VALUES
(1, '首页', 'home', '{\"tags\":[\"保洁\",\"家电清洗\",\"家电维修\",\"管道疏通\",\"家居维修\",\"家电安装\"],\"slide\":{\"img\":\"\\/assets\\/addons\\/deerhome\\/img\\/home_banner1.png,\\/assets\\/addons\\/deerhome\\/img\\/home_banner2.png\",\"json\":\"[{\\\"type\\\":\\\"item\\\",\\\"id\\\":\\\"35\\\",\\\"desc\\\":\\\"空调加氟\\\"},{\\\"type\\\":\\\"yhq\\\",\\\"id\\\":\\\"\\\",\\\"desc\\\":\\\"\\\"}]\"},\"block\":{\"show\":\"1\",\"title\":\"立即上门\",\"desc\":\"极速接单\",\"img\":\"\\/assets\\/addons\\/deerhome\\/img\\/icon_home.png,\\/assets\\/addons\\/deerhome\\/img\\/icon_bx.png,\\/assets\\/addons\\/deerhome\\/img\\/icon_gd.png,\\/assets\\/addons\\/deerhome\\/img\\/icon_dn.png\",\"json\":\"[{\\\"type\\\":\\\"item\\\",\\\"id\\\":\\\"46\\\",\\\"desc\\\":\\\"房屋维修\\\"},{\\\"type\\\":\\\"item\\\",\\\"id\\\":\\\"30\\\",\\\"desc\\\":\\\"家电维修\\\"},{\\\"type\\\":\\\"item\\\",\\\"id\\\":\\\"34\\\",\\\"desc\\\":\\\"管道疏通\\\"},{\\\"type\\\":\\\"item\\\",\\\"id\\\":\\\"110\\\",\\\"desc\\\":\\\"电脑维修\\\"}]\"},\"banner_center\":{\"img\":\"\\/assets\\/addons\\/deerhome\\/img\\/home_banner_c.png\",\"json\":\"[{\\\"type\\\":\\\"yhq\\\",\\\"id\\\":\\\"\\\",\\\"desc\\\":\\\"\\\"}]\"},\"banner_bottom\":{\"img\":\"\",\"json\":\"[]\"}}', 1, '2023-12-01 20:12:26'),
(2, '分类', 'cate', '', 2, '2023-07-07 12:11:54'),
(3, '免费领券', 'yhq', '{\"banner\":{\"img\":\"\\/assets\\/addons\\/deerhome\\/img\\/home_banner2.png\",\"json\":\"[{\\\"type\\\":\\\"no\\\",\\\"id\\\":\\\"\\\",\\\"desc\\\":\\\"\\\"}]\"}}', 3, '2023-08-01 20:51:46'),
(4, '技师入驻', 'apply', '{\"banner\":{\"img\":\"\\/assets\\/addons\\/deerhome\\/img\\/bg_apply.png\",\"json\":\"[{\\\"type\\\":\\\"no\\\",\\\"id\\\":\\\"\\\",\\\"desc\\\":\\\"\\\"}]\"}}', 4, '2023-07-11 16:36:47'),
(5, '常见问题', 'wenti', '{\"banner\":{\"img\":\"\\/assets\\/addons\\/deerhome\\/img\\/bg_kefu.png\",\"json\":\"[{\\\"type\\\":\\\"no\\\",\\\"id\\\":\\\"\\\",\\\"desc\\\":\\\"\\\"}]\"}}', 5, '2023-07-31 17:21:38');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_fapiao`
--

CREATE TABLE `__PREFIX__deerhome_fapiao` (
  `id` int(10) NOT NULL,
  `jz_user_id` int(10) NOT NULL COMMENT '用户',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待开票,2=已开票',
  `orders` varchar(500) NOT NULL COMMENT '关联订单',
  `price` decimal(10,2) NOT NULL COMMENT '开票金额',
  `type` tinyint(1) NOT NULL COMMENT '类型:1=个人,2=企业',
  `name` varchar(300) NOT NULL COMMENT '发票抬头',
  `code` varchar(60) DEFAULT NULL COMMENT '信用代码',
  `file` varchar(300) DEFAULT NULL COMMENT '下载地址',
  `add_time` datetime NOT NULL COMMENT '申请时间',
  `res_time` datetime DEFAULT NULL COMMENT '开票时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='发票管理';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_items`
--

CREATE TABLE `__PREFIX__deerhome_items` (
  `id` int(10) NOT NULL,
  `cate_id` int(10) NOT NULL COMMENT '类目',
  `anget` tinyint(1) DEFAULT '2' COMMENT '参与分销:1=是,2=否',
  `anget_lev1` decimal(5,2) DEFAULT '0.00' COMMENT '上级分佣',
  `anget_lev2` decimal(5,2) DEFAULT '0.00' COMMENT '上上级分佣',
  `item_type` tinyint(1) DEFAULT '1' COMMENT '产品类型:1=服务,2=百货',
  `name` varchar(300) NOT NULL COMMENT '服务名称',
  `status` enum('1','2') DEFAULT '1' COMMENT '状态:1=正常,2=下架',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '售价',
  `dw` varchar(100) DEFAULT NULL COMMENT '单位',
  `face_image` varchar(300) DEFAULT NULL COMMENT '封面图',
  `img_images` varchar(600) DEFAULT NULL COMMENT '图片',
  `video_file` varchar(300) DEFAULT NULL COMMENT '视频',
  `video_face_image` varchar(300) DEFAULT NULL COMMENT '视频封面图',
  `createtime` bigint(16) DEFAULT NULL,
  `updatetime` bigint(16) DEFAULT NULL,
  `deletetime` bigint(16) DEFAULT NULL,
  `weigh` int(10) DEFAULT NULL COMMENT '排序',
  `note` text COMMENT '说明',
  `body_con` text COMMENT '图文详情',
  `worker_fc_bl` decimal(5,0) NOT NULL COMMENT '分成比例',
  `view_times` int(10) DEFAULT '0' COMMENT '浏览次数',
  `sale_times` int(10) DEFAULT '0' COMMENT '销量',
  `home` tinyint(1) DEFAULT '2' COMMENT '首页:1=是,2=否',
  `recommend` tinyint(1) DEFAULT '2' COMMENT '精选:1=是,2=否',
  `fake_sale_times` int(10) DEFAULT '0' COMMENT '基础销量',
  `shop_in` tinyint(1) DEFAULT '1' COMMENT '服务方式:1=仅上门,2=仅到店,3=都可以',
  `shop_way` tinyint(1) DEFAULT '2' COMMENT '可服务门店:1=指定,2=自营,3自营+入驻',
  `shop_list` text COMMENT '支持门店列表'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='服务项目';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_items_gg`
--

CREATE TABLE `__PREFIX__deerhome_items_gg` (
  `id` int(10) NOT NULL,
  `jz_items_id` int(10) NOT NULL,
  `name` varchar(300) NOT NULL COMMENT '名称',
  `price` decimal(10,2) NOT NULL COMMENT '售价',
  `dw` varchar(50) NOT NULL COMMENT '单位',
  `weigh` int(10) DEFAULT '100' COMMENT '排序',
  `hash` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='服务规格';

--
-- 表的结构 `__PREFIX__deerhome_msg`
--

CREATE TABLE `__PREFIX__deerhome_msg` (
  `id` int(10) NOT NULL,
  `utype` tinyint(1) NOT NULL COMMENT '类型:1=消费者,2=服务人员',
  `uid` int(10) NOT NULL COMMENT '接收人',
  `msg` varchar(600) NOT NULL COMMENT '消息内容',
  `is_read` tinyint(1) DEFAULT '2' COMMENT '已读:1=是,2=否',
  `msg_type` tinyint(2) NOT NULL COMMENT '已读:1=系统消息,2=服务信息',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `read_time` datetime DEFAULT NULL COMMENT '阅读时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消息管理';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_open_city`
--

CREATE TABLE `__PREFIX__deerhome_open_city` (
  `id` int(10) NOT NULL,
  `cityname` varchar(100) NOT NULL COMMENT '城市',
  `province` varchar(100) NOT NULL COMMENT '省份'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='开放城市';

--
-- 转存表中的数据 `__PREFIX__deerhome_open_city`
--

INSERT INTO `__PREFIX__deerhome_open_city` (`id`, `cityname`, `province`) VALUES
(5, '深圳市', '广东省'),
(6, '广州市', '广东省');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_order`
--

CREATE TABLE `__PREFIX__deerhome_order` (
  `id` int(10) NOT NULL,
  `jz_user_id` int(10) NOT NULL COMMENT '用户id',
  `order_type` tinyint(1) DEFAULT '1' COMMENT '订单类型:1=服务订单,2=百货订单',
  `order_way` tinyint(1) DEFAULT '1' COMMENT '服务方式:1=上门,2=到店',
  `deerhome_shop_id` int(10) DEFAULT '0' COMMENT '门店id',
  `is_card` tinyint(1) DEFAULT '2' COMMENT '使用次卡:1=是,2=否',
  `card_order_id` int(10) DEFAULT '0' COMMENT '次卡订单ID',
  `status` tinyint(1) DEFAULT '1' COMMENT '订单状态:1=待付款,2=待派单/待发货,3=待服务,4=待验收/待签收,5=已完成,6=退款中,7=已退款,8=已取消',
  `sn` varchar(20) NOT NULL COMMENT '订单编号',
  `jz_items_id` int(10) DEFAULT '0' COMMENT '服务id',
  `gg_id` varchar(32) NOT NULL COMMENT '服务hash',
  `item_name` varchar(300) NOT NULL COMMENT '服务项目',
  `item_gg_name` varchar(300) NOT NULL COMMENT '服务规格',
  `num` tinyint(2) NOT NULL COMMENT '服务数量',
  `price_item_total` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '服务金额',
  `price_bcj` decimal(10,2) DEFAULT '0.00' COMMENT '补差价',
  `price_total` decimal(10,2) NOT NULL COMMENT '订单总金额',
  `price_light` decimal(10,2) NOT NULL COMMENT '夜间交通费',
  `price_yh` decimal(10,2) NOT NULL COMMENT '优惠金额',
  `price_discount_bl` decimal(5,2) DEFAULT '1.00' COMMENT '会员折扣比例',
  `price_discount` decimal(10,2) DEFAULT '0.00' COMMENT '会员折后总价',
  `price_need_pay` decimal(10,2) NOT NULL COMMENT '应支付金额',
  `price_payed` decimal(10,2) DEFAULT '0.00' COMMENT '已支付金额',
  `price_pre_fc` decimal(10,2) DEFAULT '0.00' COMMENT '技师预计分成',
  `pay_way` varchar(60) DEFAULT NULL COMMENT '废弃：支付方式',
  `user_name` varchar(100) NOT NULL COMMENT '联系人姓名',
  `user_phone` varchar(11) NOT NULL COMMENT '手机号',
  `address_title` varchar(100) DEFAULT NULL COMMENT '地址名称',
  `address_detail` varchar(200) DEFAULT NULL COMMENT '门牌号',
  `address_address` varchar(300) DEFAULT NULL COMMENT '详细地址',
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL,
  `date_day` date DEFAULT NULL COMMENT '预约日期',
  `date_time` time DEFAULT NULL COMMENT '预约时间',
  `note` varchar(600) NOT NULL COMMENT '备注',
  `imgs` varchar(600) DEFAULT NULL COMMENT '故障图片',
  `worker_id` int(10) DEFAULT '0' COMMENT '师傅id',
  `worker_get_time` datetime DEFAULT NULL COMMENT '师傅接单时间',
  `worker_apply_time` datetime DEFAULT NULL COMMENT '申请验收时间/核销时间',
  `worker_last_price` decimal(10,2) DEFAULT '0.00' COMMENT '差价',
  `worker_imgs` varchar(600) DEFAULT NULL COMMENT '服务图片',
  `worker_note` varchar(600) DEFAULT NULL COMMENT '服务人员备注',
  `worker_name` varchar(100) DEFAULT NULL COMMENT '师傅姓名',
  `worker_price` decimal(10,2) DEFAULT '0.00' COMMENT '师傅分成',
  `worker_price_note` varchar(300) DEFAULT NULL COMMENT '分成说明',
  `worker_price_to_wallet` tinyint(1) DEFAULT '0' COMMENT '是否结算到师傅钱包',
  `worker_pj_star` tinyint(1) DEFAULT '0' COMMENT '师傅评价星级',
  `worker_pj_con` varchar(300) DEFAULT NULL COMMENT '评价内容',
  `worker_pj_con_images` varchar(500) DEFAULT NULL COMMENT '评价图片',
  `worker_pj_nm` tinyint(1) DEFAULT '0' COMMENT '1=匿名评价',
  `worker_pj_time` datetime DEFAULT NULL COMMENT '评价时间',
  `worker_pj_star_status` tinyint(1) DEFAULT '1' COMMENT '评价是否显示:1=显示,2=隐藏',
  `worker_pj_star_good` tinyint(1) DEFAULT '2' COMMENT '精选:1=是,2=否',
  `time_add` datetime NOT NULL COMMENT '添加时间',
  `time_payed` datetime DEFAULT NULL COMMENT '支付时间',
  `time_done` datetime DEFAULT NULL COMMENT '完成时间',
  `fapiao` tinyint(1) DEFAULT '0' COMMENT '发票批次',
  `agent_lev1_uid` int(10) DEFAULT '0' COMMENT '上级uid',
  `agent_lev1_percent` decimal(6,2) DEFAULT '0.00' COMMENT '分佣百分比',
  `agent_lev1_price` decimal(10,2) DEFAULT '0.00' COMMENT '上级分佣',
  `agent_lev1_price_note` varchar(300) DEFAULT NULL COMMENT '上级分佣备注',
  `agent_lev1_price_js` tinyint(1) DEFAULT '2' COMMENT '上级是否结算:1=是,2=否',
  `agent_lev2_uid` int(10) DEFAULT '0' COMMENT '上上级uid',
  `agent_lev2_percent` decimal(6,2) DEFAULT '0.00' COMMENT '分佣百分比',
  `agent_lev2_price` decimal(10,2) DEFAULT '0.00' COMMENT '上上级分佣',
  `agent_lev2_price_note` varchar(300) DEFAULT NULL COMMENT '上上级分佣备注',
  `agent_lev2_price_js` tinyint(1) DEFAULT '2' COMMENT '上上级是否结算:1=是,2=否',
  `jf_js` tinyint(1) DEFAULT '0' COMMENT '1已结算',
  `hx_code` int(6) DEFAULT NULL COMMENT '核销码',
  `kd_gs` varchar(100) DEFAULT NULL COMMENT '快递公司',
  `kd_sn` varchar(100) DEFAULT NULL COMMENT '快递单号',
  `kd_time` datetime DEFAULT NULL COMMENT '发货时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_order_log`
--

CREATE TABLE `__PREFIX__deerhome_order_log` (
  `id` int(10) NOT NULL,
  `order_id` int(10) NOT NULL COMMENT '订单id',
  `ac_user` varchar(100) NOT NULL COMMENT '操作者',
  `note` varchar(300) NOT NULL COMMENT '内容',
  `add_time` datetime NOT NULL COMMENT '发生时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单日志';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_order_pay_log`
--

CREATE TABLE `__PREFIX__deerhome_order_pay_log` (
  `id` int(10) NOT NULL,
  `deerhome_user_id` int(10) DEFAULT '0' COMMENT '用户id',
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1=服务订单,2=充值,3=次卡订单',
  `is_wallet` tinyint(1) DEFAULT '2' COMMENT '钱包资金:1=是,2=否',
  `is_card` tinyint(1) DEFAULT '2' COMMENT '使用次卡:1=是,2=否',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单号',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待支付,2=已支付,3=已取消',
  `price` decimal(10,2) NOT NULL COMMENT '金额',
  `give` decimal(10,2) DEFAULT '0.00' COMMENT '该笔交易是否需要赠款',
  `note` varchar(300) DEFAULT NULL COMMENT '备注',
  `payway_type` tinyint(1) DEFAULT NULL COMMENT '类型:1=线上支付,2=线下支付',
  `pay_way` varchar(100) DEFAULT NULL COMMENT '支付方式',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `add_time` datetime NOT NULL COMMENT '添加时间',
  `prepay_id` varchar(70) DEFAULT NULL COMMENT '微信支付prepay_id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付日志';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_order_refund`
--

CREATE TABLE `__PREFIX__deerhome_order_refund` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待处理,2=已退款,3=已拒绝',
  `jz_user_id` int(10) NOT NULL COMMENT '用户id',
  `order_sn` varchar(50) NOT NULL COMMENT '订单号',
  `lx` varchar(80) NOT NULL COMMENT '退款类型',
  `price` decimal(10,2) NOT NULL COMMENT '订单金额',
  `price_refund` decimal(10,2) NOT NULL COMMENT '退款金额',
  `note` varchar(600) NOT NULL COMMENT '退款原因',
  `addtime` datetime NOT NULL COMMENT '申请时间',
  `ac_admin` varchar(80) DEFAULT NULL COMMENT '处理人',
  `ac_admin_time` datetime DEFAULT NULL COMMENT '处理时间',
  `ac_admin_note` varchar(600) DEFAULT NULL COMMENT '审核人备注',
  `order_old_status` tinyint(1) DEFAULT '0' COMMENT '申请退款时订单状态'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='售后管理';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_payway`
--

CREATE TABLE `__PREFIX__deerhome_payway` (
  `id` int(10) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '状态:1=开启,2=停用',
  `name` varchar(100) NOT NULL COMMENT '支付名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付方式';

--
-- 转存表中的数据 `__PREFIX__deerhome_payway`
--

INSERT INTO `__PREFIX__deerhome_payway` (`id`, `status`, `name`) VALUES
(3, 1, '支付宝收款码'),
(8, 1, '微信收款码'),
(9, 1, '现金');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_shop`
--

CREATE TABLE `__PREFIX__deerhome_shop` (
  `id` int(10) NOT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=正常,2=停用',
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1=自营,2=入驻',
  `deerhome_user_id` int(10) DEFAULT '0' COMMENT '店长id',
  `logo_images` varchar(300) DEFAULT NULL COMMENT '门店logo',
  `mdname` varchar(100) NOT NULL COMMENT '门店名称',
  `address` varchar(300) NOT NULL COMMENT '地址',
  `latitude` varchar(20) NOT NULL,
  `longitude` varchar(20) NOT NULL,
  `reg_time` datetime DEFAULT NULL COMMENT '入驻时间',
  `open_time` time DEFAULT NULL COMMENT '营业开始时间',
  `close_time` time DEFAULT NULL COMMENT '营业结束时间',
  `sfz` varchar(50) DEFAULT NULL,
  `sfz_a_image` varchar(300) DEFAULT NULL,
  `sfz_b_image` varchar(300) DEFAULT NULL,
  `yyzz_image` varchar(300) DEFAULT NULL COMMENT '营业执照',
  `address_face` varchar(300) DEFAULT NULL,
  `address1` varchar(100) DEFAULT NULL COMMENT '省份',
  `address2` varchar(100) DEFAULT NULL COMMENT '城市',
  `address3` varchar(100) DEFAULT NULL COMMENT '区域'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='门店管理';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_shop_apply`
--

CREATE TABLE `__PREFIX__deerhome_shop_apply` (
  `id` int(10) NOT NULL,
  `deerhome_user_id` int(10) NOT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待审核,2=已通过,3=未通过',
  `mdname` varchar(300) NOT NULL COMMENT '门店名称',
  `address` varchar(500) NOT NULL COMMENT '门店地址',
  `latitude` varchar(20) NOT NULL COMMENT '经度',
  `longitude` varchar(20) NOT NULL COMMENT '纬度',
  `user_name` varchar(100) NOT NULL COMMENT '负责人姓名',
  `user_tel` varchar(20) NOT NULL COMMENT '负责人手机',
  `sfz` varchar(300) NOT NULL COMMENT '身份证号',
  `sfz_a_image` varchar(300) NOT NULL COMMENT '身份证人像面',
  `sfz_b_image` varchar(300) NOT NULL COMMENT '身份证国徽面',
  `yyzz_image` varchar(300) NOT NULL COMMENT '营业执照',
  `province` varchar(100) DEFAULT NULL COMMENT '省份',
  `city` varchar(100) NOT NULL COMMENT '所在城市',
  `area` varchar(100) DEFAULT NULL COMMENT '区域',
  `note` varchar(600) NOT NULL COMMENT '申请说明',
  `add_time` datetime NOT NULL COMMENT '申请时间',
  `sh_user` varchar(100) DEFAULT NULL COMMENT '审核人',
  `sh_note` varchar(600) DEFAULT NULL COMMENT '审核备注',
  `sh_time` datetime DEFAULT NULL COMMENT '审核时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店入驻申请表';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_sms_log`
--

CREATE TABLE `__PREFIX__deerhome_sms_log` (
  `id` int(10) NOT NULL,
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1=验证码,2=通知短信',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态:1=已发送,2=发送失败',
  `tel` varchar(11) NOT NULL,
  `msg` varchar(600) NOT NULL COMMENT '短信内容',
  `code` varchar(100) NOT NULL,
  `sendtime` datetime NOT NULL,
  `is_yz` tinyint(1) DEFAULT '0' COMMENT '1为已验证',
  `yz_time` datetime DEFAULT NULL,
  `note` varchar(600) DEFAULT NULL COMMENT '发送结果说明'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_sys_charge`
--

CREATE TABLE `__PREFIX__deerhome_sys_charge` (
  `id` int(10) NOT NULL,
  `price` decimal(5,0) NOT NULL COMMENT '充值金额',
  `give` decimal(5,0) NOT NULL DEFAULT '0' COMMENT '赠款'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值配置';

--
-- 转存表中的数据 `__PREFIX__deerhome_sys_charge`
--

INSERT INTO `__PREFIX__deerhome_sys_charge` (`id`, `price`, `give`) VALUES
(1, '100', '0'),
(2, '200', '0');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_tag`
--

CREATE TABLE `__PREFIX__deerhome_tag` (
  `id` int(10) NOT NULL,
  `name` varchar(100) NOT NULL COMMENT '标签名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='标签管理';

--
-- 转存表中的数据 `__PREFIX__deerhome_tag`
--

INSERT INTO `__PREFIX__deerhome_tag` (`id`, `name`) VALUES
(1, '热情服务');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_user`
--

CREATE TABLE `__PREFIX__deerhome_user` (
  `id` int(10) NOT NULL,
  `user_lev_id` int(10) DEFAULT '0' COMMENT '会员等级',
  `jz_qd_id` int(10) DEFAULT '0' COMMENT '来源渠道',
  `face_image` varchar(300) DEFAULT NULL COMMENT '头像',
  `uname` varchar(100) DEFAULT NULL COMMENT '用户姓名',
  `utel` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `note` varchar(300) DEFAULT NULL COMMENT '备注',
  `token` varchar(150) DEFAULT NULL,
  `wxid` varchar(200) DEFAULT NULL COMMENT '微信小程序id',
  `wxid_gzh` varchar(200) DEFAULT NULL COMMENT '微信公众号id',
  `reg_ip` varchar(50) DEFAULT NULL COMMENT '注册ip',
  `regtime` datetime NOT NULL COMMENT '注册时间',
  `last_time` datetime DEFAULT NULL COMMENT '最近打开',
  `agent_lev_id` int(10) DEFAULT '0' COMMENT '分销等级',
  `agent_lev1_uid` int(10) DEFAULT '0' COMMENT '上级id',
  `agent_lev2_uid` int(10) DEFAULT '0' COMMENT '上上级id',
  `wallet_left` decimal(10,2) DEFAULT '0.00' COMMENT '可用佣金',
  `wallet_tx` decimal(10,2) DEFAULT '0.00' COMMENT '已提现佣金',
  `agent` tinyint(1) DEFAULT '2' COMMENT '分销员:1=是,2=否',
  `agent_qr` varchar(300) DEFAULT NULL COMMENT '推广二维码',
  `agent_qr_diy_bg` varchar(300) DEFAULT NULL COMMENT '自定义背景',
  `wallet_charge` decimal(10,2) DEFAULT '0.00' COMMENT '充值余额',
  `jf` int(10) DEFAULT '0' COMMENT '积分'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客户管理';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_user_address`
--

CREATE TABLE `__PREFIX__deerhome_user_address` (
  `id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `address` varchar(600) NOT NULL,
  `detail_address` varchar(300) NOT NULL,
  `lable_name` varchar(50) NOT NULL,
  `latitude` varchar(50) NOT NULL,
  `longitude` varchar(50) NOT NULL,
  `sex` enum('男','女','未知','') NOT NULL,
  `address_title` varchar(200) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `user_phone` varchar(11) NOT NULL,
  `is_default` tinyint(1) DEFAULT '0',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户地址';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_user_collected`
--

CREATE TABLE `__PREFIX__deerhome_user_collected` (
  `id` int(10) NOT NULL,
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1=收藏,2=足迹,3=页面',
  `jz_user_id` int(10) NOT NULL COMMENT '用户',
  `jz_items_id` int(10) DEFAULT '0' COMMENT '服务id',
  `note` varchar(200) DEFAULT NULL COMMENT '说明',
  `ip` varchar(30) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `province` varchar(100) DEFAULT NULL,
  `add_time` datetime NOT NULL COMMENT '操作时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_user_jf_log`
--

CREATE TABLE `__PREFIX__deerhome_user_jf_log` (
  `id` int(10) NOT NULL,
  `deerhome_user_id` int(10) NOT NULL,
  `jf` int(10) NOT NULL,
  `order_sn` varchar(100) DEFAULT NULL COMMENT '关联订单',
  `note` varchar(600) DEFAULT NULL,
  `addtime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户积分';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_user_lev`
--

CREATE TABLE `__PREFIX__deerhome_user_lev` (
  `id` int(10) NOT NULL,
  `name` varchar(300) NOT NULL COMMENT '等级名称',
  `lev` int(2) NOT NULL COMMENT '等级权重',
  `discount` decimal(5,2) NOT NULL COMMENT '会员折扣比例',
  `task` text NOT NULL COMMENT '升级条件',
  `task_type` tinyint(1) DEFAULT '1' COMMENT '条件类型:1=全部满足,2=任意一个',
  `note` varchar(600) DEFAULT NULL COMMENT '描述',
  `bg_image` varchar(300) DEFAULT NULL COMMENT '背景图'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员等级';


-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_worker`
--

CREATE TABLE `__PREFIX__deerhome_worker` (
  `id` int(10) NOT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=正常,2=停用',
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1=内部,2=入驻',
  `jz_shop_id` int(10) DEFAULT '0' COMMENT '所属门店',
  `jz_worker_lev_id` int(10) NOT NULL COMMENT '等级',
  `face_image` varchar(300) DEFAULT NULL COMMENT '头像',
  `uname` varchar(100) NOT NULL COMMENT '姓名',
  `utel` varchar(11) NOT NULL COMMENT '手机号',
  `times` int(5) DEFAULT '0' COMMENT '服务次数',
  `money_left` decimal(10,2) DEFAULT '0.00' COMMENT '可提现金额',
  `money_dj` decimal(10,2) DEFAULT '0.00' COMMENT '冻结金额',
  `money_tx` decimal(10,2) DEFAULT '0.00' COMMENT '累计提现',
  `jz_cate_ids` varchar(100) DEFAULT NULL COMMENT '服务类目',
  `jz_tag_ids` varchar(100) DEFAULT NULL COMMENT '标签',
  `sfz_a_image` varchar(150) DEFAULT NULL COMMENT '身份证正面',
  `sfz_b_image` varchar(150) DEFAULT NULL COMMENT '身份证反面',
  `zs_image` varchar(150) DEFAULT NULL COMMENT '技能证书',
  `address` varchar(200) DEFAULT NULL COMMENT '详细地址',
  `latitude` varchar(30) DEFAULT NULL,
  `longitude` varchar(30) DEFAULT NULL,
  `addtime` datetime NOT NULL COMMENT '添加时间',
  `token` varchar(100) DEFAULT NULL,
  `is_working` tinyint(1) DEFAULT '1' COMMENT '接单中:1=是,2=否',
  `wxid` varchar(100) DEFAULT NULL COMMENT '微信id',
  `info` varchar(600) DEFAULT NULL COMMENT '个人简介'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='服务人员管理';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_worker_card`
--

CREATE TABLE `__PREFIX__deerhome_worker_card` (
  `id` int(10) NOT NULL,
  `jz_worker_id` int(10) NOT NULL COMMENT '服务人员',
  `deerhome_user_id` int(10) DEFAULT '0' COMMENT '分销用户',
  `uname` varchar(100) NOT NULL COMMENT '收款人',
  `card` varchar(30) NOT NULL COMMENT '银行卡号',
  `bank` varchar(100) NOT NULL COMMENT '开户行',
  `add_time` datetime NOT NULL COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='银行卡管理';


-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_worker_day`
--

CREATE TABLE `__PREFIX__deerhome_worker_day` (
  `id` int(10) NOT NULL,
  `jz_worker_id` int(10) NOT NULL,
  `day` date NOT NULL COMMENT '日期',
  `pb_rq` varchar(180) NOT NULL COMMENT '时间；0为全天'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务人员排班';


-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_worker_lev`
--

CREATE TABLE `__PREFIX__deerhome_worker_lev` (
  `id` int(10) NOT NULL,
  `name` varchar(100) NOT NULL COMMENT '等级名称',
  `fybl` decimal(4,2) NOT NULL COMMENT '返佣比例'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务人员等级';

--
-- 转存表中的数据 `__PREFIX__deerhome_worker_lev`
--

INSERT INTO `__PREFIX__deerhome_worker_lev` (`id`, `name`, `fybl`) VALUES
(5, '默认', '0.00');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_worker_money_log`
--

CREATE TABLE `__PREFIX__deerhome_worker_money_log` (
  `id` int(10) NOT NULL,
  `type` varchar(100) NOT NULL COMMENT '类型:分销分佣,服务分成,分销提现,服务提现',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待处理,2=已处理,3=拒绝',
  `jz_worker_id` int(10) NOT NULL COMMENT '服务人员',
  `deerhome_user_id` int(10) DEFAULT '0' COMMENT '客户id',
  `jz_order_sn` varchar(100) DEFAULT NULL COMMENT '关联订单号',
  `price` decimal(10,2) NOT NULL COMMENT '金额',
  `note` varchar(300) NOT NULL COMMENT '备注',
  `skr` varchar(150) DEFAULT NULL COMMENT '收款人',
  `bank` varchar(100) DEFAULT NULL COMMENT '开户行',
  `bankcard` varchar(60) DEFAULT NULL COMMENT '银行卡',
  `sh_ren` varchar(100) DEFAULT NULL COMMENT '审核人',
  `addtime` datetime NOT NULL COMMENT '提交时间',
  `donetime` datetime DEFAULT NULL COMMENT '处理时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资金明细';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_worker_sh`
--

CREATE TABLE `__PREFIX__deerhome_worker_sh` (
  `id` int(10) NOT NULL,
  `jz_user_id` int(10) DEFAULT '0' COMMENT '用户id',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待审核,2=通过,3=拒绝',
  `face_image` varchar(100) DEFAULT NULL COMMENT '头像',
  `uname` varchar(100) NOT NULL COMMENT '姓名',
  `utel` varchar(11) NOT NULL COMMENT '手机号码',
  `idcard` varchar(50) NOT NULL COMMENT '身份证号',
  `jz_worker_lev_id` varchar(100) DEFAULT '0' COMMENT '等级',
  `jz_cate_ids` varchar(100) DEFAULT NULL COMMENT '服务类目',
  `jz_tag_ids` varchar(100) DEFAULT NULL COMMENT '标签',
  `sfz_a_image` varchar(150) NOT NULL COMMENT '身份证正面',
  `sfz_b_image` varchar(150) NOT NULL COMMENT '身份证反面',
  `zs_image` varchar(300) DEFAULT NULL COMMENT '技能证书',
  `note` varchar(300) DEFAULT NULL COMMENT '申请说明',
  `city` varchar(100) DEFAULT NULL COMMENT '城市',
  `address_title` varchar(300) NOT NULL COMMENT '地址名称',
  `address` varchar(300) DEFAULT NULL COMMENT '详细地址',
  `latitude` varchar(30) DEFAULT NULL,
  `longitude` varchar(30) DEFAULT NULL,
  `add_time` datetime NOT NULL COMMENT '提交时间',
  `sh_ren` varchar(100) DEFAULT NULL COMMENT '审核人',
  `sh_con` varchar(500) DEFAULT NULL COMMENT '审核意见',
  `sh_time` datetime DEFAULT NULL COMMENT '审核时间',
  `wx_id` varchar(300) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='服务人员审核';

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_xcxmsg`
--

CREATE TABLE `__PREFIX__deerhome_xcxmsg` (
  `id` int(10) NOT NULL,
  `title` varchar(300) NOT NULL COMMENT '模板标题',
  `tid` varchar(300) NOT NULL COMMENT '模板ID',
  `keyword` varchar(600) NOT NULL COMMENT '关键词',
  `kidListDesc` varchar(300) NOT NULL COMMENT '关键词',
  `pushed` tinyint(1) DEFAULT '2' COMMENT '是否推送到微信后台：1是，2否',
  `tplid` varchar(100) DEFAULT NULL COMMENT '微信模板id',
  `sms_template_code` varchar(100) DEFAULT NULL COMMENT '短信模板',
  `sms_open` tinyint(1) DEFAULT '2' COMMENT '是否开启:1=是,2=否',
  `sms_tpl` varchar(600) DEFAULT NULL COMMENT '短信模板'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小程序订阅消息';

--
-- 转存表中的数据 `__PREFIX__deerhome_xcxmsg`
--

INSERT INTO `__PREFIX__deerhome_xcxmsg` (`id`, `title`, `tid`, `keyword`, `kidListDesc`, `pushed`, `tplid`, `sms_template_code`, `sms_open`, `sms_tpl`) VALUES
(1, '新订单通知', '1022', '3,4,10,5,9', '订单编号,服务内容,订单金额,预约时间,备注', 2, NULL, '', 2, '您有一个新的派单，服务内容${name}，预约时间${day}，请尽快联系客户。'),
(2, '提现审核通知', '7142', '1,2,3', '审核结果,提现金额,温馨提示', 2, NULL, '', 2, '\n您的提现申请${res}，提现金额${price}'),
(3, '订单取消通知', '1023', '3,4,5,6', '订单编号,订单状态,服务内容,取消理由', 2, NULL, '', 2, '订单号${sn}已取消'),
(4, '服务人员变更通知', '2236', '7,6,4', '服务项目,服务时间,变更后服务人员', 2, NULL, '', 2, '您的订单${sn}服务人员发生变更，由${user}继续为您提供服务！'),
(5, '审核未通过提醒', '2626', '7,6,8', '审核状态,申请内容,备注', 2, NULL, '', 2, '您申请的${name}，未通过审核。'),
(6, '审核通过提醒', '2631', '6,5', '审核结果,申请内容', 2, NULL, '', 2, '您申请的${name}，已通过审核。'),
(7, '上门时间变更通知', '748', '7,3,4,8', '服务名称,原上门时间,变更后时间,备注', 2, NULL, '', 2, '您的订单服务项目${name}，服务时间变更为${day}。'),
(8, '服务派单通知', '2411', '2,3,4,8,12', '服务项目,服务信息,服务时间,服务人员,备注', 2, NULL, '', 2, '您的服务${name}已派单，${user}将为您提供服务，请保持电话畅通。');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_xcxpz`
--

CREATE TABLE `__PREFIX__deerhome_xcxpz` (
  `id` int(10) NOT NULL,
  `platform` varchar(30) NOT NULL COMMENT '标识',
  `con` text NOT NULL COMMENT '配置',
  `note` varchar(100) DEFAULT NULL COMMENT '说明',
  `update_time` datetime NOT NULL COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统配置';

--
-- 转存表中的数据 `__PREFIX__deerhome_xcxpz`
--

INSERT INTO `__PREFIX__deerhome_xcxpz` (`id`, `platform`, `con`, `note`, `update_time`) VALUES
(1, 'xcx_config', '{\"appid\":\"\",\"appsecret\":\"\",\"mch_id\":\"\",\"mch_v3_key\":\"\",\"cert_public\":\"\",\"cert_private\":\"\"}', '小程序配置', '2023-07-11 18:44:20'),
(4, 'sys', '{\"xcxtitle\":\"宇鹿家政\",\"login_logo\":\"\\/assets\\/addons\\/deerhome\\/img\\/logo.png\",\"jtf\":\"10\",\"time_start\":\"08:30\",\"time_end\":\"21:30\",\"item_bz\":\"准时上门,未服务全额退,闪电退款|7天无理由,全场包邮\",\"user_cj\":\"on\",\"worker_cj\":\"on\"}', '系统基础配置', '2023-08-18 19:42:09'),
(8, 'agent', '{\"on\":\"on\",\"fxms\":\"1\",\"lev\":\"2\",\"zgfy\":\"off\",\"hb\":\"\\/assets\\/addons\\/deerhome\\/img\\/qr_bg1.jpeg\",\"tx\":\"10\"}', '分销设置', '2023-09-08 12:53:40');

-- --------------------------------------------------------

--
-- 表的结构 `__PREFIX__deerhome_yhq`
--

CREATE TABLE `__PREFIX__deerhome_yhq` (
  `id` int(10) NOT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '状态:1=待领取,2=已领取,3=已消费,4=已过期',
  `name` varchar(300) NOT NULL COMMENT '名称',
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1=满减券',
  `jz_cate_ids` varchar(100) NOT NULL COMMENT '使用范围',
  `money_lev` decimal(10,2) NOT NULL COMMENT '消费满金额',
  `money_yh` decimal(10,2) NOT NULL COMMENT '减免金额',
  `start_day` date NOT NULL COMMENT '有效日期',
  `end_day` date NOT NULL COMMENT '失效日期',
  `code` varchar(30) NOT NULL COMMENT '券码',
  `addtime` datetime NOT NULL COMMENT '创建时间',
  `jz_user_id` int(10) DEFAULT '0' COMMENT '领取用户',
  `order_sn` varchar(20) DEFAULT NULL COMMENT '消费订单号',
  `get_time` datetime DEFAULT NULL COMMENT '领取时间',
  `use_time` datetime DEFAULT NULL COMMENT '消费时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠券';
--
-- 转储表的索引
--

--
-- 表的索引 `__PREFIX__deerhome_agent_lev`
--
ALTER TABLE `__PREFIX__deerhome_agent_lev`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_article`
--
ALTER TABLE `__PREFIX__deerhome_article`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_bank`
--
ALTER TABLE `__PREFIX__deerhome_bank`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_card`
--
ALTER TABLE `__PREFIX__deerhome_card`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_card_items`
--
ALTER TABLE `__PREFIX__deerhome_card_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deerhome_card_id` (`deerhome_card_id`),
  ADD KEY `deerhome_items_gg_id` (`deerhome_items_gg_hash`);

--
-- 表的索引 `__PREFIX__deerhome_card_order`
--
ALTER TABLE `__PREFIX__deerhome_card_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sn` (`sn`),
  ADD KEY `deerhome_user_id` (`deerhome_user_id`),
  ADD KEY `status` (`status`),
  ADD KEY `deerhome_card_id` (`deerhome_card_id`);

--
-- 表的索引 `__PREFIX__deerhome_card_order_items`
--
ALTER TABLE `__PREFIX__deerhome_card_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deerhome_card_order_id` (`deerhome_card_order_id`);

--
-- 表的索引 `__PREFIX__deerhome_cate`
--
ALTER TABLE `__PREFIX__deerhome_cate`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_config`
--
ALTER TABLE `__PREFIX__deerhome_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- 表的索引 `__PREFIX__deerhome_design`
--
ALTER TABLE `__PREFIX__deerhome_design`
  ADD PRIMARY KEY (`id`);


--
-- 表的索引 `__PREFIX__deerhome_fapiao`
--
ALTER TABLE `__PREFIX__deerhome_fapiao`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_items`
--
ALTER TABLE `__PREFIX__deerhome_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cate_id` (`cate_id`);

--
-- 表的索引 `__PREFIX__deerhome_items_gg`
--
ALTER TABLE `__PREFIX__deerhome_items_gg`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`jz_items_id`);

--
-- 表的索引 `__PREFIX__deerhome_msg`
--
ALTER TABLE `__PREFIX__deerhome_msg`
  ADD PRIMARY KEY (`id`),
  ADD KEY `utype` (`utype`),
  ADD KEY `msg_type` (`msg_type`);

--
-- 表的索引 `__PREFIX__deerhome_open_city`
--
ALTER TABLE `__PREFIX__deerhome_open_city`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_order`
--
ALTER TABLE `__PREFIX__deerhome_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sn` (`sn`),
  ADD UNIQUE KEY `hx_code` (`hx_code`),
  ADD KEY `status` (`status`),
  ADD KEY `gg_id` (`gg_id`),
  ADD KEY `worker_id` (`worker_id`);

--
-- 表的索引 `__PREFIX__deerhome_order_log`
--
ALTER TABLE `__PREFIX__deerhome_order_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`);

--
-- 表的索引 `__PREFIX__deerhome_order_pay_log`
--
ALTER TABLE `__PREFIX__deerhome_order_pay_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `deerhome_user_id` (`deerhome_user_id`);

--
-- 表的索引 `__PREFIX__deerhome_order_refund`
--
ALTER TABLE `__PREFIX__deerhome_order_refund`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`jz_user_id`);

--
-- 表的索引 `__PREFIX__deerhome_payway`
--
ALTER TABLE `__PREFIX__deerhome_payway`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_shop`
--
ALTER TABLE `__PREFIX__deerhome_shop`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_shop_apply`
--
ALTER TABLE `__PREFIX__deerhome_shop_apply`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deerhome_user_id` (`deerhome_user_id`),
  ADD KEY `status` (`status`);

--
-- 表的索引 `__PREFIX__deerhome_sms_log`
--
ALTER TABLE `__PREFIX__deerhome_sms_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`);

--
-- 表的索引 `__PREFIX__deerhome_sys_charge`
--
ALTER TABLE `__PREFIX__deerhome_sys_charge`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_tag`
--
ALTER TABLE `__PREFIX__deerhome_tag`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_user`
--
ALTER TABLE `__PREFIX__deerhome_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token` (`token`),
  ADD UNIQUE KEY `utel` (`utel`),
  ADD KEY `user_lev_id` (`user_lev_id`);

--
-- 表的索引 `__PREFIX__deerhome_user_address`
--
ALTER TABLE `__PREFIX__deerhome_user_address`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`user_id`);

--
-- 表的索引 `__PREFIX__deerhome_user_collected`
--
ALTER TABLE `__PREFIX__deerhome_user_collected`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`);

--
-- 表的索引 `__PREFIX__deerhome_user_jf_log`
--
ALTER TABLE `__PREFIX__deerhome_user_jf_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_user_lev`
--
ALTER TABLE `__PREFIX__deerhome_user_lev`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_worker`
--
ALTER TABLE `__PREFIX__deerhome_worker`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token` (`token`);

--
-- 表的索引 `__PREFIX__deerhome_worker_card`
--
ALTER TABLE `__PREFIX__deerhome_worker_card`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_worker_day`
--
ALTER TABLE `__PREFIX__deerhome_worker_day`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_worker_lev`
--
ALTER TABLE `__PREFIX__deerhome_worker_lev`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_worker_money_log`
--
ALTER TABLE `__PREFIX__deerhome_worker_money_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_worker_sh`
--
ALTER TABLE `__PREFIX__deerhome_worker_sh`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jz_user_id` (`jz_user_id`);

--
-- 表的索引 `__PREFIX__deerhome_xcxmsg`
--
ALTER TABLE `__PREFIX__deerhome_xcxmsg`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_xcxpz`
--
ALTER TABLE `__PREFIX__deerhome_xcxpz`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `__PREFIX__deerhome_yhq`
--
ALTER TABLE `__PREFIX__deerhome_yhq`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `jz_user_id` (`jz_user_id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_agent_lev`
--
ALTER TABLE `__PREFIX__deerhome_agent_lev`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_article`
--
ALTER TABLE `__PREFIX__deerhome_article`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_bank`
--
ALTER TABLE `__PREFIX__deerhome_bank`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_card`
--
ALTER TABLE `__PREFIX__deerhome_card`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_card_items`
--
ALTER TABLE `__PREFIX__deerhome_card_items`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_card_order`
--
ALTER TABLE `__PREFIX__deerhome_card_order`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_card_order_items`
--
ALTER TABLE `__PREFIX__deerhome_card_order_items`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=130;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_cate`
--
ALTER TABLE `__PREFIX__deerhome_cate`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_config`
--
ALTER TABLE `__PREFIX__deerhome_config`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_design`
--
ALTER TABLE `__PREFIX__deerhome_design`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_fapiao`
--
ALTER TABLE `__PREFIX__deerhome_fapiao`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_items`
--
ALTER TABLE `__PREFIX__deerhome_items`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_items_gg`
--
ALTER TABLE `__PREFIX__deerhome_items_gg`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1004;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_msg`
--
ALTER TABLE `__PREFIX__deerhome_msg`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_open_city`
--
ALTER TABLE `__PREFIX__deerhome_open_city`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_order`
--
ALTER TABLE `__PREFIX__deerhome_order`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_order_log`
--
ALTER TABLE `__PREFIX__deerhome_order_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_order_pay_log`
--
ALTER TABLE `__PREFIX__deerhome_order_pay_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=140;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_order_refund`
--
ALTER TABLE `__PREFIX__deerhome_order_refund`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_payway`
--
ALTER TABLE `__PREFIX__deerhome_payway`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_shop`
--
ALTER TABLE `__PREFIX__deerhome_shop`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_shop_apply`
--
ALTER TABLE `__PREFIX__deerhome_shop_apply`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_sms_log`
--
ALTER TABLE `__PREFIX__deerhome_sms_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_sys_charge`
--
ALTER TABLE `__PREFIX__deerhome_sys_charge`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_tag`
--
ALTER TABLE `__PREFIX__deerhome_tag`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_user`
--
ALTER TABLE `__PREFIX__deerhome_user`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_user_address`
--
ALTER TABLE `__PREFIX__deerhome_user_address`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_user_collected`
--
ALTER TABLE `__PREFIX__deerhome_user_collected`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_user_jf_log`
--
ALTER TABLE `__PREFIX__deerhome_user_jf_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_user_lev`
--
ALTER TABLE `__PREFIX__deerhome_user_lev`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_worker`
--
ALTER TABLE `__PREFIX__deerhome_worker`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_worker_card`
--
ALTER TABLE `__PREFIX__deerhome_worker_card`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_worker_day`
--
ALTER TABLE `__PREFIX__deerhome_worker_day`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_worker_lev`
--
ALTER TABLE `__PREFIX__deerhome_worker_lev`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_worker_money_log`
--
ALTER TABLE `__PREFIX__deerhome_worker_money_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_worker_sh`
--
ALTER TABLE `__PREFIX__deerhome_worker_sh`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_xcxmsg`
--
ALTER TABLE `__PREFIX__deerhome_xcxmsg`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_xcxpz`
--
ALTER TABLE `__PREFIX__deerhome_xcxpz`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- 使用表AUTO_INCREMENT `__PREFIX__deerhome_yhq`
--
ALTER TABLE `__PREFIX__deerhome_yhq`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;


INSERT INTO `__PREFIX__auth_rule` (`id`, `type`, `pid`, `name`, `title`, `icon`, `url`, `condition`, `remark`, `ismenu`, `menutype`, `extend`, `py`, `pinyin`, `createtime`, `updatetime`, `weigh`, `status`) VALUES
(85, 'file', 0, 'deerhome', '宇鹿家政pro版', 'fa fa-circle-o', '', '', '宇鹿家政', 1, 'addtabs', '', 'yljzpb', 'yulujiazhengproban', 1714967052, 1714979040, 200, 'normal'),
(86, 'file', 85, 'deerhome/info', '概览', 'iconfont icon-gaikuang', '', '', '', 1, NULL, '', 'gl', 'gailan', 1714967052, 1714967052, 500, 'normal'),
(87, 'file', 86, 'deerhome/info/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(88, 'file', 85, 'deerhome/order-0', '订单', 'iconfont icon-xiangmugaikuang_0', '', '', '', 1, NULL, '', 'dd', 'dingdan', 1714967052, 1714967052, 300, 'normal'),
(89, 'file', 88, 'deerhome/order', '服务订单', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fwdd', 'fuwudingdan', 1714967052, 1714967052, 300, 'normal'),
(90, 'file', 89, 'deerhome/order/log', '日志', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'rz', 'rizhi', 1714967052, 1714967052, 0, 'normal'),
(91, 'file', 89, 'deerhome/worker/selectpage', '选择服务人员', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xzfwry', 'xuanzefuwurenyuan', 1714967052, 1714967052, 0, 'normal'),
(92, 'file', 89, 'deerhome/order_pay_log/index', '支付流水', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zfls', 'zhifuliushui', 1714967052, 1714967052, 0, 'normal'),
(93, 'file', 89, 'deerhome/order/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1714967052, 1714967052, 0, 'normal'),
(94, 'file', 89, 'deerhome/order/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(95, 'file', 89, 'deerhome/order/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(96, 'file', 89, 'deerhome/order/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(97, 'file', 89, 'deerhome/order/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(98, 'file', 89, 'deerhome/order/paidan', '派单', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'pd', 'paidan', 1714967052, 1714967052, 0, 'normal'),
(99, 'file', 88, 'deerhome/order_refund', '退款/售后', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'tksh', 'tuikuanshouhou', 1714967052, 1714967052, 280, 'normal'),
(100, 'file', 99, 'deerhome/order_refund/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(101, 'file', 99, 'deerhome/order_refund/edit', '审核', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sh', 'shenhe', 1714967052, 1714967052, 0, 'normal'),
(102, 'file', 88, 'deerhome/evaluate', '评价管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'pjgl', 'pingjiaguanli', 1714967052, 1714967052, 100, 'normal'),
(103, 'file', 102, 'deerhome/evaluate/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(104, 'file', 102, 'deerhome/evaluate/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(105, 'file', 102, 'deerhome/evaluate/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(106, 'file', 102, 'deerhome/evaluate/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(107, 'file', 102, 'deerhome/evaluate/multi', '状态精选', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'ztjx', 'zhuangtaijingxuan', 1714967052, 1714967052, 0, 'normal'),
(108, 'file', 88, 'deerhome/card_order', '次卡订单', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'ckdd', 'cikadingdan', 1714967052, 1714967052, 299, 'normal'),
(109, 'file', 108, 'deerhome/card_order/index', '列表', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'lb', 'liebiao', 1714967052, 1714967052, 0, 'normal'),
(110, 'file', 108, 'deerhome/card_order/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1714967052, 1714967052, 0, 'normal'),
(111, 'file', 108, 'deerhome/card_order/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(112, 'file', 88, 'deerhome/goods_order', '百货订单', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'bhdd', 'baihuodingdan', 1714967052, 1714967052, 290, 'normal'),
(113, 'file', 85, 'deerhome/user', '客户', 'iconfont icon-fuwurenyuanguanli', '', '', '', 1, NULL, '', 'kh', 'kehu', 1714967052, 1714967052, 290, 'normal'),
(114, 'file', 113, 'deerhome/user/index', '客户管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'khgl', 'kehuguanli', 1714967052, 1714967052, 10, 'normal'),
(115, 'file', 114, 'deerhome/user_collected/index', '收藏足迹查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sczjzk', 'shoucangzujizhakan', 1714967052, 1714967052, 0, 'normal'),
(116, 'file', 114, 'deerhome/user/wallet_charge', '充值', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'cz', 'chongzhi', 1714967052, 1714967052, 0, 'normal'),
(117, 'file', 114, 'deerhome/user/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(118, 'file', 114, 'deerhome/user/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(119, 'file', 114, 'deerhome/user/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(120, 'file', 114, 'deerhome/user/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(121, 'file', 113, 'deerhome/user_lev', '会员等级', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'hydj', 'huiyuandengji', 1714967052, 1714967052, 9, 'normal'),
(122, 'file', 121, 'deerhome/user_lev/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(123, 'file', 121, 'deerhome/user_lev/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(124, 'file', 121, 'deerhome/user_lev/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(125, 'file', 121, 'deerhome/user_lev/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(126, 'file', 121, 'deerhome/user_lev/set_lev', '设置等级', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'szdj', 'shezhidengji', 1714967052, 1714967052, 0, 'normal'),
(127, 'file', 85, 'deerhome/fw', '产品', 'iconfont icon-fuwu7', '', '', '', 1, NULL, '', 'cp', 'chanpin', 1714967052, 1714967052, 200, 'normal'),
(128, 'file', 127, 'deerhome/items', '服务项目', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fwxm', 'fuwuxiangmu', 1714967052, 1714967052, 201, 'normal'),
(129, 'file', 128, 'deerhome/cate/cate2', '服务下拉列表', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'fwxllb', 'fuwuxialaliebiao', 1714967052, 1714967052, 0, 'normal'),
(130, 'file', 128, 'deerhome/cate/selectpage2', '类目下拉', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'lmxl', 'leimuxiala', 1714967052, 1714967052, 0, 'normal'),
(131, 'file', 128, 'deerhome/items/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(132, 'file', 128, 'deerhome/items/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(133, 'file', 128, 'deerhome/items/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(134, 'file', 128, 'deerhome/items/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(135, 'file', 128, 'deerhome/items/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(136, 'file', 127, 'deerhome/cate', '类目管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'lmgl', 'leimuguanli', 1714967052, 1714967052, 0, 'normal'),
(137, 'file', 136, 'deerhome/cate/selectpage', '上级类目', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sjlm', 'shangjileimu', 1714967052, 1714967052, 0, 'normal'),
(138, 'file', 136, 'deerhome/cate/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(139, 'file', 136, 'deerhome/cate/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(140, 'file', 136, 'deerhome/cate/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(141, 'file', 136, 'deerhome/cate/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(142, 'file', 136, 'deerhome/cate/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(143, 'file', 127, 'deerhome/card', '套餐次卡', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'tcck', 'taocancika', 1714967052, 1714967052, 200, 'normal'),
(144, 'file', 143, 'deerhome/card/index', '列表', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'lb', 'liebiao', 1714967052, 1714967052, 0, 'normal'),
(145, 'file', 143, 'deerhome/card/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(146, 'file', 143, 'deerhome/card/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(147, 'file', 143, 'deerhome/card/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(148, 'file', 143, 'deerhome/card/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(149, 'file', 143, 'deerhome/items_gg/index', '选择产品', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xzcp', 'xuanzechanpin', 1714967052, 1714967052, 0, 'normal'),
(150, 'file', 127, 'deerhome/goods', '百货商品', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'bhsp', 'baihuoshangpin', 1714967052, 1714967052, 190, 'normal'),
(151, 'file', 85, 'deerhome/fwry', '员工', 'iconfont icon-fuwu5', '', '', '', 1, NULL, '', 'yg', 'yuangong', 1714967052, 1714967052, 100, 'normal'),
(152, 'file', 151, 'deerhome/worker', '服务人员管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fwrygl', 'fuwurenyuanguanli', 1714967052, 1714967052, 99, 'normal'),
(153, 'file', 152, 'deerhome/worker_day/index', '排班管理查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'pbglzk', 'paibanguanlizhakan', 1714967052, 1714967052, 0, 'normal'),
(154, 'file', 152, 'deerhome/worker_day/add', '排班维护', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'pbwh', 'paibanweihu', 1714967052, 1714967052, 0, 'normal'),
(155, 'file', 152, 'deerhome/worker_day/del', '排班删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'pbsc', 'paibanshanchu', 1714967052, 1714967052, 0, 'normal'),
(156, 'file', 152, 'deerhome/worker/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(157, 'file', 152, 'deerhome/worker/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(158, 'file', 152, 'deerhome/worker/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(159, 'file', 152, 'deerhome/worker/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(160, 'file', 152, 'deerhome/worker/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(161, 'file', 151, 'deerhome/worker_sh', '人员入驻审核', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'ryrzsh', 'renyuanruzhushenhe', 1714967052, 1714967052, 99, 'normal'),
(162, 'file', 161, 'deerhome/worker_sh/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(163, 'file', 161, 'deerhome/worker_sh/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(164, 'file', 161, 'deerhome/worker_sh/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(165, 'file', 161, 'deerhome/worker_sh/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(166, 'file', 161, 'deerhome/worker_sh/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(167, 'file', 151, 'deerhome/worker_lev', '服务人员等级', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fwrydj', 'fuwurenyuandengji', 1714967052, 1714967052, 98, 'normal'),
(168, 'file', 167, 'deerhome/worker_lev/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(169, 'file', 167, 'deerhome/worker_lev/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(170, 'file', 167, 'deerhome/worker_lev/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(171, 'file', 167, 'deerhome/worker_lev/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(172, 'file', 151, 'deerhome/tag', '标签管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'bqgl', 'biaoqianguanli', 1714967052, 1714967052, 0, 'normal'),
(173, 'file', 172, 'deerhome/tag/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(174, 'file', 172, 'deerhome/tag/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(175, 'file', 172, 'deerhome/tag/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(176, 'file', 172, 'deerhome/tag/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(177, 'file', 172, 'deerhome/tag/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(178, 'file', 85, 'deerhome/cw', '财务', 'iconfont icon-caiwu2', '', '', '', 1, NULL, '', 'cw', 'caiwu', 1714967052, 1714967052, 90, 'normal'),
(179, 'file', 178, 'deerhome/fwtx', '提现审核', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'txsh', 'tixianshenhe', 1714967052, 1714967052, 10, 'normal'),
(180, 'file', 179, 'deerhome/fwtx/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(181, 'file', 179, 'deerhome/fwtx/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967052, 1714967052, 0, 'normal'),
(182, 'file', 179, 'deerhome/fwtx/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967052, 1714967052, 0, 'normal'),
(183, 'file', 179, 'deerhome/fwtx/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967052, 1714967052, 0, 'normal'),
(184, 'file', 179, 'deerhome/fwtx/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967052, 1714967052, 0, 'normal'),
(185, 'file', 178, 'deerhome/fapiao', '发票管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fpgl', 'fapiaoguanli', 1714967052, 1714967052, 8, 'normal'),
(186, 'file', 185, 'deerhome/fapiao/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967052, 1714967052, 0, 'normal'),
(187, 'file', 185, 'deerhome/fapiao/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(188, 'file', 185, 'deerhome/fapiao/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(189, 'file', 185, 'deerhome/fapiao/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(190, 'file', 185, 'deerhome/fapiao/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967053, 1714967053, 0, 'normal'),
(191, 'file', 178, 'deerhome/order_pay_log', '收支流水', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'szls', 'shouzhiliushui', 1714967053, 1714967053, 8, 'normal'),
(192, 'file', 178, 'deerhome/money_log', '结算明细', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'jsmx', 'jiesuanmingxi', 1714967053, 1714967053, 7, 'normal'),
(193, 'file', 192, 'deerhome/money_log/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(194, 'file', 178, 'deerhome/worker_card', '银行卡管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'yhkgl', 'yinhangkaguanli', 1714967053, 1714967053, 0, 'normal'),
(195, 'file', 194, 'deerhome/worker_card/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(196, 'file', 194, 'deerhome/worker_card/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(197, 'file', 178, 'deerhome/bank', '银行管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'yhgl', 'yinhangguanli', 1714967053, 1714967053, 0, 'normal'),
(198, 'file', 197, 'deerhome/bank/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(199, 'file', 197, 'deerhome/bank/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(200, 'file', 197, 'deerhome/bank/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(201, 'file', 197, 'deerhome/bank/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(202, 'file', 197, 'deerhome/bank/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967053, 1714967053, 0, 'normal'),
(203, 'file', 178, 'deerhome/charge_sys', '充值配置', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'czpz', 'chongzhipeizhi', 1714967053, 1714967053, 0, 'normal'),
(204, 'file', 203, 'deerhome/charge_sys/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(205, 'file', 203, 'deerhome/charge_sys/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(206, 'file', 203, 'deerhome/charge_sys/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(207, 'file', 85, 'deerhome/yx', '营销', 'iconfont icon-yingxiao', '', '', '', 1, NULL, '', 'yx', 'yingxiao', 1714967053, 1714967053, 80, 'normal'),
(208, 'file', 207, 'deerhome/yhq', '优惠券', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'yhq', 'youhuiquan', 1714967053, 1714967053, 0, 'normal'),
(209, 'file', 208, 'deerhome/yhq/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(210, 'file', 208, 'deerhome/yhq/add', '创建优惠券', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'cjyhq', 'chuangjianyouhuiquan', 1714967053, 1714967053, 0, 'normal'),
(211, 'file', 208, 'deerhome/yhq/edit', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1714967053, 1714967053, 0, 'normal'),
(212, 'file', 208, 'deerhome/yhq/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(213, 'file', 85, 'deerhome/agent', '分销', 'iconfont icon-fenxiao4', '', '', '', 1, NULL, '', 'fx', 'fenxiao', 1714967053, 1714967053, 75, 'normal'),
(214, 'file', 213, 'deerhome/agent_user', '分销员管理', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fxygl', 'fenxiaoyuanguanli', 1714967053, 1714967053, 10, 'normal'),
(215, 'file', 214, 'deerhome/agent_user/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(216, 'file', 214, 'deerhome/agent_user/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1714967053, 1714967053, 0, 'normal'),
(217, 'file', 214, 'deerhome/agent_user/set_lev', '设置等级', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'szdj', 'shezhidengji', 1714967053, 1714967053, 0, 'normal'),
(218, 'file', 214, 'deerhome/agent_user/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(219, 'file', 214, 'deerhome/agent_user/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(220, 'file', 213, 'deerhome/agent_order', '分销订单', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fxdd', 'fenxiaodingdan', 1714967053, 1714967053, 9, 'normal'),
(221, 'file', 220, 'deerhome/agent_order/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(222, 'file', 213, 'deerhome/agent_lev', '分销等级', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fxdj', 'fenxiaodengji', 1714967053, 1714967053, 8, 'normal'),
(223, 'file', 222, 'deerhome/agent_lev/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(224, 'file', 222, 'deerhome/agent_lev/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(225, 'file', 222, 'deerhome/agent_lev/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(226, 'file', 222, 'deerhome/agent_lev/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(227, 'file', 213, 'deerhome/agent_config', '分销设置', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'fxsz', 'fenxiaoshezhi', 1714967053, 1714967053, 0, 'normal'),
(228, 'file', 227, 'deerhome/agent_config/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(229, 'file', 85, 'deerhome/design', '装修', 'iconfont icon-yingxiao8', '', '', '', 1, 'addtabs', '', 'zx', 'zhuangxiu', 1714967053, 1714967115, 80, 'normal'),
(230, 'file', 229, 'deerhome/design/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(231, 'file', 229, 'deerhome/design/items', '首页设计', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sysj', 'shouyesheji', 1714967053, 1714967053, 0, 'normal'),
(232, 'file', 229, 'deerhome/design/home', '首页', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sy', 'shouye', 1714967053, 1714967053, 0, 'normal'),
(233, 'file', 229, 'deerhome/design/actions', '选择链接', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xzlj', 'xuanzelianjie', 1714967053, 1714967053, 0, 'normal'),
(234, 'file', 229, 'deerhome/design/cates', '类目选择', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'lmxz', 'leimuxuanze', 1714967053, 1714967053, 0, 'normal'),
(235, 'file', 85, 'deerhome/wzgl', '文章', 'iconfont icon-wenzhang1', '', '', '', 1, NULL, '', 'wz', 'wenzhang', 1714967053, 1714967053, 70, 'normal'),
(236, 'file', 235, 'deerhome/article?c=2', '常见问题', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'cjwt', 'changjianwenti', 1714967053, 1714967053, 10, 'normal'),
(237, 'file', 236, 'deerhome/article/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(238, 'file', 235, 'deerhome/article?c=1', '使用协议', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'syxy', 'shiyongxieyi', 1714967053, 1714967053, 0, 'normal'),
(239, 'file', 238, 'deerhome/article/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(240, 'file', 238, 'deerhome/article/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(241, 'file', 238, 'deerhome/article/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(242, 'file', 85, 'deerhome/pz', '设置', 'iconfont icon-shezhi1', '', '', '', 1, NULL, '', 'sz', 'shezhi', 1714967053, 1714967053, 0, 'normal'),
(243, 'file', 242, 'deerhome/sys', '基本配置', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'jbpz', 'jibenpeizhi', 1714967053, 1714967053, 10, 'normal'),
(244, 'file', 243, 'deerhome/sys/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(245, 'file', 242, 'deerhome/payway', '线下支付配置', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'xxzfpz', 'xianxiazhifupeizhi', 1714967053, 1714967053, 0, 'normal'),
(246, 'file', 245, 'deerhome/payway/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(247, 'file', 245, 'deerhome/payway/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(248, 'file', 245, 'deerhome/payway/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(249, 'file', 245, 'deerhome/payway/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(250, 'file', 245, 'deerhome/payway/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967053, 1714967053, 0, 'normal'),
(251, 'file', 242, 'deerhome/open_city', '开放城市', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'kfcs', 'kaifangchengshi', 1714967053, 1714967053, 0, 'normal'),
(252, 'file', 251, 'deerhome/open_city/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(253, 'file', 251, 'deerhome/open_city/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(254, 'file', 251, 'deerhome/open_city/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(255, 'file', 251, 'deerhome/open_city/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(256, 'file', 251, 'deerhome/open_city/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967053, 1714967053, 0, 'normal'),
(257, 'file', 242, 'deerhome/xcxmsg', '消息配置', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'xxpz', 'xiaoxipeizhi', 1714967053, 1714967053, 0, 'normal'),
(258, 'file', 257, 'deerhome/xcxmsg/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(259, 'file', 257, 'deerhome/xcxmsg/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(260, 'file', 257, 'deerhome/xcxmsg/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(261, 'file', 257, 'deerhome/xcxmsg/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(262, 'file', 257, 'deerhome/xcxmsg/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967053, 1714967053, 0, 'normal'),
(263, 'file', 242, 'deerhome/config', '系统配置', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'xtpz', 'xitongpeizhi', 1714967053, 1714967053, 0, 'normal'),
(264, 'file', 85, 'deerhome/shopcenter', '门店', 'iconfont icon-fuwu11', '', '', '', 1, 'addtabs', '', 'md', 'mendian', 1714967053, 1714967109, 98, 'normal'),
(265, 'file', 264, 'deerhome/shop', '门店管理', 'fa fa-sitemap', '', '', '', 1, NULL, '', 'mdgl', 'mendianguanli', 1714967053, 1714967053, 80, 'normal'),
(266, 'file', 265, 'deerhome/shop/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1714967053, 1714967053, 0, 'normal'),
(267, 'file', 265, 'deerhome/shop/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1714967053, 1714967053, 0, 'normal'),
(268, 'file', 265, 'deerhome/shop/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1714967053, 1714967053, 0, 'normal'),
(269, 'file', 265, 'deerhome/shop/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1714967053, 1714967053, 0, 'normal'),
(270, 'file', 265, 'deerhome/shop/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1714967053, 1714967053, 0, 'normal'),
(271, 'file', 264, 'deerhome/shop_apply', '门店入驻审核', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'mdrzsh', 'mendianruzhushenhe', 1714967053, 1714967053, 0, 'normal'),
(272, 'file', 271, 'deerhome/shop_apply/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1714967053, 1714967053, 0, 'normal'),
(273, 'file', 271, 'deerhome/shop_apply/sh', '审核', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sh', 'shenhe', 1714967053, 1714967053, 0, 'normal'),
(274, 'file', 271, 'deerhome/shop_apply/index', '列表', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'lb', 'liebiao', 1714967053, 1714967053, 0, 'normal'),
(275, 'file', 112, 'deerhome/goods_order/index', '查看', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'zk', 'zhakan', 1714979732, 1714979759, 0, 'normal'),
(276, 'file', 112, 'deerhome/goods_order/detail', '订单详情', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'ddxq', 'dingdanxiangqing', 1714979931, 1714979931, 0, 'normal'),
(277, 'file', 112, 'deerhome/goods_order/log', '日志', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'rz', 'rizhi', 1714979973, 1714979973, 0, 'normal'),
(278, 'file', 112, 'deerhome/goods_order/fahuo', '发货', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'fh', 'fahuo', 1714980047, 1714980047, 0, 'normal'),
(279, 'file', 150, 'deerhome/goods/index', '查看', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'zk', 'zhakan', 1714980864, 1714980864, 0, 'normal'),
(280, 'file', 150, 'deerhome/goods/add', '添加', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'tj', 'tianjia', 1714980898, 1714980898, 0, 'normal'),
(281, 'file', 150, 'deerhome/goods/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'bj', 'bianji', 1714980911, 1714980911, 0, 'normal'),
(282, 'file', 150, 'deerhome/goods/del', '删除', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'sc', 'shanchu', 1714980924, 1714980924, 0, 'normal'),
(283, 'file', 150, 'deerhome/goods/multi', '切换状态', 'fa fa-circle-o', '', '', '', 0, 'addtabs', '', 'qhzt', 'qiehuanzhuangtai', 1714981083, 1714981083, 0, 'normal');

COMMIT;


SET FOREIGN_KEY_CHECKS = 1;
